Solved: Matrix Total Wrong and How to calculate percentage... - Page 2

mdvillanueva · ‎10-25-2017

Hi so this is how my work looks like. This has thousands of columns and millions of rows. I wanted to be able to get a result like this.

Can you suggest the next steps? I am new to using power bi so I am very sorry 😞

BILASolution · ‎10-25-2017

Try this steps...

1. This is my sample data with a table called "Table" (You need to replace it by your table's name)

2. Create the next measures

Total Value = SUM('Table'[Value])

Total per Row = CALCULATE([Total Value];ALLEXCEPT('Table';'Table'[C1]))

Percentage = DIVIDE([Total Value];[Total per Row])

NOTE: "C1" becomes rows in the matrix visual and "C2" becomes columns.

3. This is how the result look like...

I hope this helps

Regards

BILASolution

Matrix Total Wrong and How to calculate percentages of each cell