Implement different RLS for 2 measures in same table.

[alexa_0028]

Hi All,

I have  a scenario where in 2 measures from same table should have different RLS.
One measure should filter from ofa_sa_calls and another one from ofa_sa_country.

So, as a solution I duplicated the table and separated the measure and now creating filters in the role like below.
My one table is connected to ofa_sa_calls and other to ofa_sa_country.

However, I am not getting right results in the report. When I see the result in database it looks good but in powerbi doesn't match.
Any ideas here pls?

[VijayP]

@alexa_0028 

In power bi desktop if you test it looks fine but when you publish and check this in service , you will be able to see all data because you are the owner for that!

once you publish then the end user will be able to see the changed scenario.

But one important thing you need to notice, if you share both RLS enabled reports to single user, the user can see both scenarios in the report. 

Does that  make sense?!