Forum Discussion

kirb's avatar
kirb
Frequent Visitor
3 years ago
Solved

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...

2 Replies

  • kirb's avatar
    kirb
    Frequent Visitor

    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's avatar
    mlsx4
    Icon for Memorable Member rankMemorable Member

    Hi kirb 

     

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