how to hide a value from a column in my report if there is no value in another column

[Anonymous]

Dear All

Happy new year 2024!

i am building a report which shows the apps shared with external users (i use the COE Starter kit tables / Audit logs)

We can find in External user UPN some external users who had a connection but the app has been deleted.

Could you please let me know how i can create my formula :

if the app has no value (because deleted), then hide the external user who connected to this app. 

Thank you very much, i m learning power bi : ) 

[amitchandak · Accepted solution]

@Anonymous , You can use RLS to remove Data access

Power BI- Row Level Security(RLS): Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc

You can use userprincipalname in a measure to check and make value blank

if(isblank(Table[Measure]) && not( userprincipalname() in value[Email[Email])), blank(), [Measure 2])

We can not do it for columns.