Forum Discussion
Helper IIFilter a Gauge visual without affecting maximum value but the progress bar?
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!
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.
1 Reply
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.