Matrix Total Wrong and How to calculate percentages of each cell

[mdvillanueva]

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 😞 

[mdvillanueva]

Sir @BILASolution

I was able to figure things out! Thank you again for this! You really saved me today!

[BILASolution]

@mdvillanueva

If you have any problems. Enter here

Matrix

[BILASolution · Accepted solution]

Hi @mdvillanueva

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

[mdvillanueva]

@BILASolution

It says 'error' with the second script 😞 

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

[BILASolution]

@mdvillanueva

What's the error Message???

[mdvillanueva]

@BILASolution

Oh it was because of the use of ;

I replaced ';' with ',' and it worked!

[BILASolution]

Ok   

[mdvillanueva]

Hi Sir! @BILASolution 😞

I did what you instructed me to do. But it wont show. You can look at the photo for reference.

[BILASolution]

@mdvillanueva

Change the data type of "Value" column by "Whole Number"

[mdvillanueva]

@BILASolution

Sir, all of the cells are 0% 😞 

[mdvillanueva]

@BILASolution

Sir! I was able to figure things out! Thanks again! You really saved me today! 🙂 

[mdvillanueva]

@BILASolution

Currently trying to figure it out using your instructions. Thank you very much sir!!! 🙂

Though I have to clarify, what does it mean with 'First' and 'Last' in the value field? Does that divides my data?