Dividing Matrix row Grandtotal by every row to get a % of the Grandtotal

[Anonymous]

Hello All,

I have been stumped on this issue for a few days.  It appears when I try to write a measure in which I intend to incorporate the Grandtotal, I am instead referencing one of the section totals as per below.  My intention was to have every row in the column divide by the grandtotal even the subtotals so the underlined in blue grandtotals would = 100%.  

Here is the formula I am currently using, any suggestions would be greatly appreciated 🙂  Have a great day!

% of grandtotal test = DIVIDE(

SUM('csv'[TradeCount]),

CALCULATE(SUM('csv'[TradeCount]), ALL('csv'[TradeType]))

)

[johnt75 · Accepted solution]

Assuming that 'csv[Trade type] is the column which is in the rows, you would also need to remove the filters on whichever column the Yes / No is coming from, e.g. ALL('csv'[Yes / no])

[Anonymous]

Thanks for the reply!.. I think I got what you are saying and this is the reformulated logic and the result.  Any thoughts?  

% of grandtotal test = DIVIDE(

SUM('csv'[TradeCount]),

CALCULATE(SUM('csv'[TradeCount]),

ALL('csv'[TradeType]),

ALL('csv'[P-BK Trade])

))

[Anonymous]

sorry forgot the output:

[johnt75]

That looks correct. It seems to be indicating that you have rows which do not fall in to either Yes or No.

[Anonymous]

You are correct my friend.  Thank you so much!