KPI Visual Issue (Blank Value)

[brunoctesser]

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 erase the filters, making it consider every month/year, it displays a blank value. Considering it does not have any month/year filtering it, shouldn't it display the total for all the months/years? It does in a card visual. What am I missing?

And how can I make it show the total, or at least prevent the end user to select all month/years and in turn display this wrong value?

Thank you.

[rachelgomez1234]

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

[lukiz84]

Can you share some sample data for the table "Geral"?