Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
2 |