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