Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |