11-29-2018 12:45 AM
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.