Removing Filter Context with All

[Max_B]

Hi everyone, 
I looked in a few forums and posts but could not find the answer. I am looking to remove the slicer context on a visual with two slicers. This used to be easily possible with All, however I cannot get it to work. I have a very simple dataset with 2 relevant columns (Name, industry). I want to remove the affect of the industry slicer and only show the selected name.

The code I use is:

Var Company5 = CALCULATE(

        max('Score Sheet'[What is the name of your company?])

        ,All('Score Sheet'[In which industry does your company operate?])

        )

return Company5

This does not remove the industry filter however, as is still applies (see picture). I tried the same with removefilters. 

Thanks for your support

[XeniaLi]

Why just not stop interaction form this slicer In which industry does your company operate? to the card?

[Max_B]

Is not that correct - The measure should be agnostic to the industry part and specific to the name. So if I remove one filter through ALL(Table[Industy]) it should be showing what the name filters and not be empty right?

[v-sgandrathi · Accepted solution]

Hi @Max_B,

You are correctly removing the Industry filter using ALL('Score Sheet'[Industry]), but the reason your visual shows blank is that your data context depends on both Name and Industry together. When you remove only the Industry filter, it can create ambiguity if multiple records exist for the same Name across different Industries, leading to a blank result. To properly achieve your goal, making the measure agnostic to Industry but still responding to Name -- it is better to use REMOVEFILTERS instead of ALL.

If my response was helpful, consider clicking "Accept as Solution" and give us "Kudos" so that other community members can find it easily. Let me know if you need any more assistance!

Thank you.

[v-sgandrathi]

Hi @Max_B,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[v-sgandrathi]

Hi @Max_B 

I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.

Thank you.

[v-sgandrathi]

Hi  @Max_B ,

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.

If you need any further assistance, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[lbendlin]

you removed all filters on a single column, keeping filters on other columns intact.

ALL(Table[Column])

ALL(Table)

ALL()

have different scope.