Question about Row Totals for Total Line

[kirb]

HI guys, 

I need help. 

I have this table. the KPI3 is basically KPI2/KPI1. 

What I unfortunately get is the version below with 100% in the total line for Peter. 

But what I want is that it calculates the 24% correctly. 

Power BI always tells me that I have to add something like the SUM or MAX in front of the KPIs so i added SUM. If I do not do this I dont get anything. 

Does this problem ring a bell to anybody? I also activated the Row Total % thing but it never comes up with the 24% for the total. 

I am grateful for any help. 

thank you

[kirb · Accepted solution]

well thank you. it was not exactly what i was looking for but you have lead me on another way and i found a solution which involves 3 new calculation columns and then a DIVIDE function...

[mlsx4]

Hi @kirb 

I think you need to include a SUMX(VALUES(Status), KPI2/KPI1)