I have a table with different measures, My slicer no need to filter every measures in the table. Is

[Anonymous]

I have a table with different measures, My slicer no need to filter every measures in the table. Is it possible?

[V-pazhen-msft · Accepted solution]

@Anonymous 

It's really depend on the formula of your measures. Usually, for those measures you want it to be filtered by the slice , you use Allselected () as the filter context, and for those you do not want to filter, you use ALL() statement.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38]

@Anonymous 

you need to create your measures with respect with your potential slicer by using ALL(), ALLEXCEPT(), ALLSELECTED() statements in your measures

[Fowmy]

@Anonymous 

Not quite clear about what you are trying to ask. Can you share some data and expected output with explanation?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn