Forum Discussion

brunoctesser's avatar
brunoctesser
Helper I
3 years ago

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 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.

Need Help

2 Replies

  • lukiz84's avatar
    lukiz84
    Memorable Member
    3 years ago

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

  • rachelgomez1234's avatar
    rachelgomez1234
    Helper I
    3 years ago

    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