Forum Discussion
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 work anymore (it just sums the Calc KPI Index values instead of calculating them again).
How can I solve this problem with this Custom Visual (I'm using the Row_Based_Metrics)? Is it possible to modify the Calc KPI Index formula so it calculates it again when I want to see the KPI for the whole company instead of only one country?
Thanks in advance for your support.
13 Replies
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 .....
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
If you would compare countries we would recommend that you should add a Power KPI Matrix for each country.
Please let us know if that meets your requirements.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Good day,
Actually it does not meet my requirements.
My organization is divided in geographical areas (Europe, America, Asia, etc), and each area has lots of countries in it. The goal is to have one visual with all the KPIs and the possibility to see them for the whole organization, for a single area or for a single country (using filters). This is actually possible with this Visual, the only thing that does not work is the KPI Indicator Status.
Is there a way to fix it?
Thanks in advance for your reply.You just need to include a filter for each area (Country, Region, etc.).
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
