using DAX to calculate % of column total

[Anonymous]

Hi,

I looked at other similar posts but could not see an answer for this particular query. I am using DAX to calculate % of column total (it has to be done using DAX).

However the percentage is a result of division by the grand total, not the sub-total!

For example I have 7 subcategories as columns which are split by row categories and there are 1534 items in total overall - for the first subcategory column there are 36 items, a particular row has 14. Therefore I am looking to see 14/36 = 38.89%. But instead I get 0.91% which is 14/1534.

%Required = [EOMCount12]/calculate([EOMCount12],ALLSELECTED())

Cause is the row of table

Subcategory is column of table

EOMCount12 is the values

Please help!

[AlB · Accepted solution]

Hi @Anonymous 

I would need more info but you probably need to include the subcategory column in the ALLSELECTED( ) if that's the total you want to compute the % over:

%Required = [EOMCount12]/calculate([EOMCount12], ALLSELECTED( Table1[Subcategory] ) )

[Anonymous]

Solved this by adding cause to Allselected...