Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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,
This thread was super-useful.
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,
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.