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.
Community SupportHi 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.
Community SupportHi 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!