percent of total ( ignore selection)

[alihijazi]

Hello got the following charts

 we have expenses that are classified as General and Other; so here general expenses represents 63 percent of all expenses and this is correct

Now when user select a slice in the below pie chart the above gauge shows 100% as follows:

whereas I need to show that EDL represents around 33% of all instead of 100%

so How can I ignore selection of EDL for the denomenator?

[jahida · Accepted solution]

The ALL function is your friend here:

https://msdn.microsoft.com/en-us/library/ee634802.aspx

Can't give more specific guidance without seeing the formulas.

[joglidden2]

This thread was super-useful. 

[v-sihou-msft · Accepted solution]

@alihijazi

As mentioned, you just need to put "All(Table)" in your total calculation to ignore the selection.

Pct Of Total = CALCULATE(SUM('Table'[Column]))/CALCULATE(SUM('Table'[Column]),ALL('Table'))

Regards,

[jahida · Accepted solution]

The ALL function is your friend here:

https://msdn.microsoft.com/en-us/library/ee634802.aspx

Can't give more specific guidance without seeing the formulas.