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