Forum Discussion
kirb
3 years agoFrequent Visitor
Question about Row Totals for Total Line
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
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...