Known Limitations

This document provides a list of limitations of AtScale's support for DAX Tabular. It also lists unsupported and non-applicable functions.

Limitations

• Filters on Measures are not supported.
• Quick Measures using Time Intelligence calculations work only with date hierarchies provided by Power BI.
• Quick Measure - Sales from new customers work only with PBI-provided date hierarchy.
• SELECTEDVALUE DAX function will always return a blank result for Totals unless the filters end up with a single value on the visualization.

Unsupported Functions

If a function is not explicitly listed as supported, then it should be considered unsupported. Where indicated, some unsupported functions have server-side analogues that should be used instead.

• Filter - ALLEXCEPT, ALLSELECTED, CALCULATETABLE, FILTER, KEEPFILTERS, SELECTEDVALUE
• Financial - ACCRINT, COUPDAYS, EFFECT, FV, INTRRATE, and so on.
• Information - COLUMNSTATISTICS, CONTAINSROW, CUSTOMDATA, and so on.
• MEDIAN - Use AtScale's Percentile Measure Functions
• Math and Trig - FACT, GCD, LCM, MROUND, ROUNDUP, ROUNDDOWN.
• PERCENTILE - Use AtScale's Percentile Measure functions.
• Parent and Child - PATH, PATHCONTAINS, PATHLENGTH, and so on.
• STDEV - Use AtScale's Sample or Population Standard Deviation Measure functions.
• Statistical Distribution Functions - BETA, CHISQ, EXPON, GEOMEAN, NORM, T
• Table Manipulation Functions - GENERATE, INTERSECT, NATURALINNERJOIN, NATURALLEFTOUTERJOIN, and so on.
• Time Intelligence - See Supported Functions list for the subset of supported functions. All others are unsupported.
• VAR - Use AtScale's Sample or Population Variance Measure functions.

Non-Applicable Functions

The following functions are not applicable to Tabular connections to AtScale because all relationship definitions and navigation direction are defined in the AtScale Model.

Table Relationship Functions:

• CROSSFILTER
• RELATED
• RELATEDTABLE
• USERELATIONSHIP