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.