Forum Discussion
Sanskruti
Helper II
3 years agopage level filter in measure
Hello,
I have created a measure and applied a page level filter.
I dont want my measure to change when the filter is applied.
How can i do it?
Thanks
1 Reply
- AjithPrasath
Resolver II
Use the Allselected() function inside the measure so that it won't change with page level filter
MyMeasure = CALCULATE ( <expression>, ALLSELECTED () )
ALLSELECTED() as the filter argument, you ensure that the measure ignores any filters applied at the page level. The ALLSELECTED function preserves the current filter context while removing any additional filters that could affect the measure's calculation.
Best Regards,
Ajith Prasath
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.