topic Re: Question about Row Totals for Total Line in DAX Commands and Tips

Question about Row Totals for Total Line

kirb — Mon, 04 Sep 2023 12:15:06 GMT

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

Re: Question about Row Totals for Total Line

mlsx4 — Mon, 04 Sep 2023 13:09:57 GMT

Hi kirb

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

Re: Question about Row Totals for Total Line

kirb — Mon, 04 Sep 2023 14:45:18 GMT

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