Forum Discussion
KPI Visual Issue (Blank Value)
I have the following measure which gives me the water consumption: A KPI Visual displays this information, it works fine as long as I have a month/year filtering it: But as soon as I er...
The problem is the FILTER('Table1';'Table1'[TotalScore]=1) that you have as a CALCULATE filter argument.
Change them to 'Table1'[TotalScore]=1 and your two measures should be OK.
This is equivalent to using FILTER(ALL('Table1'[TotalScore]),'Table1'[TotalScore]=1) which gives the same result but is a bit long-winded.
Hope that works for you
Regards,
Rachel Gomez