Forum Discussion
Removing Filter Context with All
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.
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-sgandrathiCommunity Support
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.