Reply
Highlighted
New Member
Posts: 1
Registered: ‎11-29-2018

Measure blank when filter on all or multiple members selected.

Hello all,

 

In my Power BI dashboard I have calculated a measure with the following DAX statement:

 

VCA Index = (CALCULATE(SUM('FACT - ROLAP'[DATA_VALUE]),FILTER('FACT - ROLAP','FACT - ROLAP'[Measure]="VCA-index"))) / 100

 

This gives me back a value from the Fact table, which is a percentage. I also have the filters 'Years' and 'Periods'. I don't want the measure to aggregate when my 'periods' or 'years' filter is on 'ALL' or multiple members are selected. Then I want the measure to be empty (NULL/BLANK).

 

So for example: when my periods filter is on 'period 3' I want the value of the DAX statement. But when my periods filter is on 'ALL', I want it to be BLANK.

 

I have tried some things but it didn't work out. Hopefully you can give me some advise.

 

Thanks in advance.

 

Mike