How could I get a Total number from other two column total number?

[Anonymous]

Hi all,

I have a table. I want to get Space Usage %'s number in total session. However, I don't want get sum total. I want the number is for whole DCs. So the space usage % in total row= total used cabinets/total cabinets. Could I know how to get this number in Power BI? 

Thank you so much!

Best,

Rebecca

[jthomson]

No idea what you're using for space usage % right now, but a standard measure such as:

space usage% = divide([total cabinets], [used cabinets])

Ought to do exactly that if your cabinet columns are measures, or if you've just dropped a column in, sum the columns and divide them?

[Anonymous]

Hi,

Thank you for your help! I just want to have one space usage % number in the total session. And only aggregated function is SUM, Average, Minimum, Maximum, Count, Stadard deviation which I do not want use it.  Also if I create a new measure or new calculated column, it will just create new column. However, the total session still cannot get the number using Total Used Cabinets/ Total Cabinet (for all DC) 

[jthomson · Accepted solution]

I've just entered your data into a table, and then put dc as rows, then the rest as values:

(image removed)

Power BI does what you want out of the box in seconds - you've not accidentally turned off some totals in the visual settings by any chance?