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 cube 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