Percentage of grand total

[abv46mac]

Hi!

I'm trying to get percentafe of gran total in a matrix. In that matrix i've got normal values. How i can do that? 

[v-sihou-msft]

@abv46mac

You can create a measure with ALLSESLECTED to get the grand total within matrix. 

Measure = CALCULATE(SUM(Table[Value]),ALLSELSECTED(Table))

Then you can have cell level field divided by above measure:

Pct= SUM(Table[Value])/CALCULATE(SUM(Table[Value]),ALLSELSECTED(Table))

Regards,

[abv46mac]

 Hi Simon, first thanks for your reply.

It works nicely but, allselected keep the filters outside the query, is there any possible to avoid this?

When I agregate 2 dimensions in cascade the percentage doens't work, I thin might be beacuse of filters.

thanks in advance.

[v-sihou-msft · Accepted solution]

@abv46mac

If you want to ignore the filter, you can replace ALLSELECTED with ALL().

Measure = CALCULATE(SUM(Table[Value]),ALL(Table))

Pct= SUM(Table[Value])/CALCULATE(SUM(Table[Value]),ALL(Table))

 Regards,