KPI to show % sum of values instead of last value

[KarmaP]

I have a set of KPI cards I am creating that I want to show the total percentage instead of the last %. I have tried using the stand alone Microsoft KPI card and I have also tried the KPI Indicator visual that is available for download. The KPI Indicator allows Sum, Average, and Value. Unfortuantley the Average seems to be taking the average of all the %s in the dataset and not the values of the dax formula in totality.

The KPI sparkline graph looks great and exaclty correct, its just the KPI value that is wrong. Example data with what it is doing now vs what I want it to do.

[Nabha-Ahmed]

hi @KarmaP 

Thanks for the explanation! That makes sense — the KPI card was averaging the row-level percentages instead of calculating the overall percentage from totals. Your solution with SUM(Value) / SUM(Total) is exactly what I needed. Appreciate you sharing it!

[Nabha-Ahmed]

hi @KarmaP 

Thanks for the explanation! That makes sense — the KPI card was averaging the row-level percentages instead of calculating the overall percentage from totals. Your solution with SUM(Value) / SUM(Total) is exactly what I needed. Appreciate you sharing it!

[LaurelB]

Were you able to find a resolution to this? I'm having the same problem. KPI visual shows the last month's metric, but I want to show the metric percent over the full time period.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[amitchandak]

@KarmaP , Are you using a measure like

divide( sum(Table[Expense Amount]), Sum(Table[Base Amount]) )

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[KarmaP]

Can't post right now but yea I am doing that exact formula.  Very simple. 

the KPI will return the last value in the time series. So for this example doing the formula you suggest returns 5% when using the standard PowerBI KPI visual. 

when trying the downloaded KPI indicator visual it shows the same but as the option for sim or average instead of last value. The sum just adds up all the %s which is wrong and the average isn't right either.