Forum Discussion

Lemaxa's avatar
Lemaxa
New Member
4 years ago

SNL / RLS : remove filtering on rows for some visuals

Dear community,   I have a PowerBI project in which I need to implemented SNL. To be more precise, I should implement SNL in a company that has many subsidiaries.   The problem is that I have som...
Show and Tell
Icey's avatar
Icey
Community Support
4 years ago

Hi Lemaxa ,

 

 

In my report, I want to show only A = 'Yes' when I select the A role. But I also need to show that 66% of subsidiaries (2/3 subsidiaries in total) are in France, whatever the role I have.

 

Have you tried to use ALL function to ignore the effect of the slicer? Here is an example. Not the same but can refer:

 

Reference: ALL Ignores the Filter Coming from One Table

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Lemaxa's avatar
    Lemaxa
    New Member
    4 years ago

    Hello Icey 

    Thanks a lot for your reply.

     

    This is not what I meant. If you use that solution and you implement SNL, you will have the same problem I have, because SNL is "erasing" the lines that are not related to your role...

     

    Best

     

    Maxime