Percentage by row total (similar to excel) in power BI

[Ortignano]

I have a table by categories and Year and I would calculate the category percentage by row total as in the picture.

On the left a sample data, on the right what I have using formula below and in the bottom the expected result (I have only one table).

I use:
% of Total Measure = DIVIDE ( CALCULATE ( SUM ( Table1[Qtà fallita] ) ), CALCULATE ( SUM ( Table1[Qtà fallita] ), ALL ( Table1[Error type 2], Table1[Year] )),0)

But it doesn't work as it calculate the percentage of overall and not by row

[Uzi2019 · Accepted solution]

Hi @Ortignano 

Try below measure 

% of Total Measure =

DIVIDE ( CALCULATE ( SUM ( Table1[Qtà fallita] ) ), CALCULATE ( SUM ( Table1[Qtà fallita] ), ALLSELECTED ( Table1[Year] )),0)

% of Total Measure =

DIVIDE ( CALCULATE ( SUM ( Table1[Qtà fallita] ) ), CALCULATE ( SUM ( Table1[Qtà fallita] ), ALL ( Table1[Year] )),0)

Check this result every row total is having 100%

I hope I answered your question!

[Ortignano · Accepted solution]

Thank you, all the solutions works well!

[Anonymous]

Hi @Ortignano 

It seems that you have gotten a solution. Could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards    

Zhengdong Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Uzi2019 · Accepted solution]

Hi @Ortignano 

Try below measure 

% of Total Measure =

DIVIDE ( CALCULATE ( SUM ( Table1[Qtà fallita] ) ), CALCULATE ( SUM ( Table1[Qtà fallita] ), ALLSELECTED ( Table1[Year] )),0)

% of Total Measure =

DIVIDE ( CALCULATE ( SUM ( Table1[Qtà fallita] ) ), CALCULATE ( SUM ( Table1[Qtà fallita] ), ALL ( Table1[Year] )),0)

Check this result every row total is having 100%

I hope I answered your question!

[Kedar_Pande]

try updating your measure like this:

% of Total by Row = 
DIVIDE(
SUM(Table1[Qtà fallita]),
CALCULATE(SUM(Table1[Qtà fallita]), ALLEXCEPT(Table1, Table1[Error type 2])),
0
)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn