Forum Discussion
Calculated Measure Not Changing with Filters/Slicers
Hi there, the addition of "ALL ( 'disputes' ) " in your measure is having the affect of keeping you from filtering.
When adding a function to a measure normally you can see the specific intention in a pop - for "ALL" the pop up says 'Returns all the rows in a table, or all the values in a column, IGNORING ANY FILTERS that might have been applied)....
The last bit of that comment in the fucntion = "might" = is important, what they (microsoft) actually mean is it WILL ignore ALL filters.. wether or not they are applied... but to be sure check to see if there is one in the side "filter" bar. I assume you made this dashboard, but in case you didn't sometimes people filter things, then hide the side filter bar..
Just remove "ALL" and you'll be fine
Kind regards
Clin EPI
Advocate IIIHi there, the addition of "ALL ( 'disputes' ) " in your measure is having the affect of keeping you from filtering.
When adding a function to a measure normally you can see the specific intention in a pop - for "ALL" the pop up says 'Returns all the rows in a table, or all the values in a column, IGNORING ANY FILTERS that might have been applied)....
The last bit of that comment in the fucntion = "might" = is important, what they (microsoft) actually mean is it WILL ignore ALL filters.. wether or not they are applied... but to be sure check to see if there is one in the side "filter" bar. I assume you made this dashboard, but in case you didn't sometimes people filter things, then hide the side filter bar..
Just remove "ALL" and you'll be fine
Kind regards
Clin EPI
After changing the data type in PowerQuery rather than in the data view, this worked. Thank you kindly!