Measure to display data if exists or specific text if there is no value in a table visual

[cosminzanfir]

Hello Power BI developers.
I would need your help with the following scenario.
On one report, I am showing to the consumers where they have access by displaying their email address agains all the zones where they have access in a table visual. All this information is coming from one single table that holds the RLS setup.

What i want to do is to show a specific message (Contact your administrator or zone admin to grant access) in case they do not have access to any of the zone.
The issue here is that when i try to display it in a table visual, is ok until I simulate a user that does not have access.
I figured, there is something wrong with my measure.
The way i wrote the measure is:

VAR SeeZones = COUNTROWS( RLS[Zone])
VAR MyUsersZone =DISTINCT (
SELECTCOLUMNS (
FILTER (RLS,
UPPER ( RLS[emailaddress] ) = UPPER ( USERPRINCIPALNAME () )
&& SeeZones > 0),
"Zone", RLS[Zone]))

RETURN
MyUsersZone


please advice

[hnguy71]

Hi @cosminzanfir 

Assuming you already have your RLS set up. your measure to show a specific message should be pretty simple:

VAR _HasZone = CALCULATE(COUNTROWS(RLS), NOT(ISBLANK((RLS[Zone])))) > 0
RETURN
IF( NOT(_HasZone), "Contact yourr administrator or zone admin to grant access.")