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.
I have a table with powercentrals and their installed capacity (which is 740 MW). However, I want to filter by type of powercentral, zone, status, etc. but as I created a quick measure to sum all capacities, of course those filters will affect the measure. I included an example of what happens if I add a filter.
In the picture at the right I filtered by "Stabilized Price" which is showing me a correct number of 289, but I'd like to see a 289 of a maximum of 740 MW. Is there a way to achieve this, and if it's possible, showing percentage instead of a decimal number?
Thanks!
Solved! Go to Solution.
You need to create another measure that remains constant regardless of the filters you have e.g.
InstalledCapacity = CALCULATE([Capacity],ALL('Capabity_Tbl'))
You can use above ALL function to remove the filter context of a measure. If you need to have some columns filter for that table then add ALL for each individual column you don't want to filter your value.
You need to create another measure that remains constant regardless of the filters you have e.g.
InstalledCapacity = CALCULATE([Capacity],ALL('Capabity_Tbl'))
You can use above ALL function to remove the filter context of a measure. If you need to have some columns filter for that table then add ALL for each individual column you don't want to filter your value.
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 |
---|---|
106 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |