Skip to main content

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​

Filters on Measures are not supported.

Quick measures​

  • 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​

The SELECTEDVALUE function will always return a blank result for Totals unless the filters end up with a single value on the visualization.

IF / SWITCH​

For the IF and SWITCH functions, comparing dimensions to measures is not supported. (ATSCALE-14804)

ADDCOLUMNS​

The ADDCOLUMNS function will not work if you attempt to create a calculation using it like this:

VAR tab0 = ADDCOLUMNS('Customer',"customerCount", COUNT('Customer'[Customer.Key0]))
VAR tab1 = FILTER(tab0, [customerCount]>100)
VAR sumTab0 = CALCULATE([Internet Sales Amount Local],tab1)

In this example, we count on a dimensional attribute and then filter it. This isn't supported.

It is expected to work if you want to perform aggregations over Measures, like in the examples below:

129_ATSCALE-14859-AddColumnsPostAggFilterMeasures_AND = VAR tab0 = ADDCOLUMNS('CubeMeasures', "rsales", [Reseller Sales Amount Local], "isales", [Internet Sales Amount Local])
VAR tab1 = FILTER(tab0, AND([rsales] > 500000, [isales] > 1000000))
VAR sumTab0 = CALCULATE('CubeMeasures' [Internet Sales Amount Local], tab1)
RETURN sumTab0

129_ATSCALE-14859-AddColumnsPostAggFilterMeasures_OR = VAR tab0 = ADDCOLUMNS('CubeMeasures', "rsales", [Reseller Sales Amount Local], "isales", [Internet Sales Amount Local])
VAR tab1 = FILTER(tab0, OR([rsales] < 600000, [isales] > 1000000))
VAR sumTab0 = CALCULATE('CubeMeasures' [Internet Sales Amount Local], tab1)
RETURN sumTab0

130_ATSCALE-14859-AddColumnsWithPostFilterUsingAggAndGroupColumn = var x = ADDCOLUMNS('Product', "isgood", IF ([Color] = "Blue", "Good", "Not good"))
    var y = FILTER(x, OR([isgood] = "Good", 'Product'[Category] = "Bikes"))
    return calculate([Internet Sales Amount Local] , y)

KEEPFILTERS / REMOVEFILTERS​

The KEEPFILTERS and REMOVEFILTERS functions can only reference secondary attributes.

RANKX​

Results of expressions using RANKX can only be grouped by attributes included in the expressions.

Additionally, RANKX always returns a blank result for Grand Totals.

ALLEXCEPT​

The ALLEXCEPT function can only be used to control the filter context on either model measures or specific measures.

For example:

ALLEXCEPT(CubeMeasures, DateCustom[Reporting Day2])

ALLEXCEPT([Internet Sales Amount Local], DateCustom[Reporting Day2])

ALLEXCEPT cannot be used on hierarchies.

SUBSTITUTE​

For the SUBSTITUTE function, AtScale does not support the instance_num parameter.

ATSCALE-14867

Unsupported Functions​

If a function is not explicitly listed as supported, then it should be considered unsupported.

Some unsupported functions have server-side analogues that should be used instead:

  • MEDIAN - Use AtScale's Percentile Measure functions.
  • PERCENTILE - Use AtScale's Percentile Measure functions.
  • STDEV - Use AtScale's Sample or Population Standard Deviation 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