page level filter in measure

[Sanskruti]

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

[AjithPrasath]

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.