Forum Discussion

FraNat's avatar
FraNat
Frequent Visitor
8 years ago

KPI Matrix - Calc KPI Index issue

In the example file of Power KPI Matrix it is possible to filter the visual by Country, but if I want to see, for instance, both France and Germany together then the KPI Indicator Status does not wor...
rexii23's avatar
rexii23
Advocate I
8 years ago

This is not completely related to the KPI visual but I have experienced the same issue with some of my metrics in other standard visuals such as tables.

 

It all depends on what you want the result to be when you add in aggregation. For this instance, I gather you want to sum the countries first for each metric and then do the actual calculation such work out variance to target. So it is sum then divide. The default behaviour could be divide then sum.

 

To solve this, I had to write a custom dax formula to ensure the calculation is correct. I can find the example right now but from memory it involves SUMX(FILTER(VALUES .....

  • v-viig's avatar
    v-viig
    Community Champion
    8 years ago

    As a quick workaround you might put the country column into Hyperlink data-field.

    Such workaround forces Power BI to stop summarize KPI Index.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]