Matrix Percent of total

[EZimmet]

Good Day and Thank You all. 

Currently have #1
Need to create #2  --- "What I need to produce an output showing percent of Data Center used by each Company.

Total Rack Cnt / Total Number of Companies broken down by each Data Center Location "

#1

#2

[Ritaf1983 · Accepted solution]

Hi @EZimmet 
Visually it can look something like that :

logically you can create 2 measures :
1 for Total Rack Cnt:

Total Rack Cnt = sum('Table'[Rack Cnt])

2 for percentage

Percentage = [Total Rack Cnt]/CALCULATE([Total Rack Cnt],ALLEXCEPT('Table','Table'[Data Center Location]))

Link to the sample file 

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

[EZimmet · Accepted solution]

TY so much for the solution -- Sorry for the delay in accepting I was OOO 

[Ritaf1983]

@EZimmet  Happy to help 🙂

[Ritaf1983 · Accepted solution]

Hi @EZimmet 
Visually it can look something like that :

logically you can create 2 measures :
1 for Total Rack Cnt:

Total Rack Cnt = sum('Table'[Rack Cnt])

2 for percentage

Percentage = [Total Rack Cnt]/CALCULATE([Total Rack Cnt],ALLEXCEPT('Table','Table'[Data Center Location]))

Link to the sample file 

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