Dynamic Measure based on RLS or Filter

[billuran]

Hi, Simplistic version; I have 3+ facilities. 2 Of the facilities (FacA & FacB) do not report the data I want to show so I have to show a different measure when they are selected.

Facilities are stored in Table Facilities. Named as FacilitiesName

Measure A if any of the 2 facilities are filtered. 

Measure B if neither of the 2 are selected.

And to note the 2 facilities could be filtered through RLS not by slicer.

[amitchandak]

@billuran , see if Perspectives can help. RLS is data level security , no measure level

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2020-feature-summary/#_Perspectives