Skip to main content
Version: I2023.2.0

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