Forum Discussion

ewill_bdg's avatar
ewill_bdg
Regular Visitor
9 years ago

Add Row Percentage

I need to add a colomn  Matrix that calculate the percentage (%) of UNITs "ON MOVE":     I almost got it, the problem is that it calculate it for all the columns.    How Can I Calculate the ...
Need Help
ewill_bdg's avatar
ewill_bdg
Regular Visitor
9 years ago

This is how i have configured the Matrix:

 

Row: UNITS

 

Column: STATUS1

 

Values : SUM[STATUS1]

            COUNT[STATUS1]   show value as percentage row of total

 

I hope this helps.

kjsullivan's avatar
kjsullivan
Frequent Visitor
9 years ago

ewill_bdg

 

Yes that helps me understand a little more. 

 

You will do this Measure first. This should get the Sum of a Status. I am still a little confused on your fields so I just did a basic template. The table should be the table your status is in and column should be the status. The Table is what you called your data when you orignally loaded it into Power Bi. For example, the table is Sheet 1. The columns I have are Alphabet and Number. And the values are in Alphabet and Number. So if I wanted the Sum of letter a I would do 

Sum of Letter = CALCULATE (
 COUNT (Sheet1[Alphabet]),Sheet1[Alphabet]="a")

.

 

Sum of On Move Available  = CALCULATE (
 COUNT (Table[Coulmn]),Table[Coulmn]="value")

 

I think what you need to do next is create a second measure that finds the SUM of all avilable between all the different statuses. 

This would be 

CountValues = CALCULATE ( COUNT ( TableName ), TableName[ColumnName])

 

then you would do the divide.

 

Sum of % = DIVIDE([Sum of On Move Available],[Sum of All Available])

 

This would give you the % of only On Move. You could change up the first measure created per value.

 

I hope this helps!