We have requirement to anonymize data(field values) for some of the users and it should work dynamically.
I have Employee table with employee details and one new field has been introduced called "Anonymized" with values Yes and No.
Currently, RLS is applied on employee table (employee name=userprinciplename()).
There are two table charts in Power BI which uses direct columns(name,email,phone) from different DIM table(Customer details). The requirement is if user belong to anonymized category(Yes) then all the field should show as "Anonyized" else show actual values.
Request you all to please guide or share me the related link to achieve such requirement.
Thanks in advance.
Solved! Go to Solution.
Hi @SarikaKumari18 ,
Is this what you want?
Step1, Set RLS.
Step2, Set the data with [Anonymized data]="YES" to anonymous.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-lionel-msft ,
Thanks for looking into this. we have written below measure to meet the requirement.
Hi Amit, I am writing the below measure
You can try like this ?
sumx(values(Table[employee]) , if(max(Table[Anonyized]) ="Yes", [measure1], [measure2]))
Thanks for a quick response ,
I have tried the above DAX and it throws me an error : "the function sumx cannot work with values of type string"
@amitchandak Could you please help me to resolve this and also, the solution should work dynmically based on user log in.
It would be great help and really appreciate this.
Click here to learn more about the August 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.