divding row value ith total column value

[mehaboob557]

Hello all,

Can any one help me how to achieve diving row value ith total column value

here i am diving the rowvalue with total column value. How can i achieve this in Power BI.

so here for each row value i have to do the division with the total of this column.

Thank you in advance

[vik0810 · Accepted solution]

Use Function ALLSELECTED to calculate the whole Sum, like that:

Total Sum = CALCULATE(SUM(TotalPrice), ALLSELECTED(put here the column you building total price for))

Then you can calculate the percentage

DIVIDE(SUM(TotalPrice), [Total Sum])