Dynamic Security

[K_demmons]

Hey, I could use some help.

I've been trying to follow sqlbi's example on customizing default values for each user, but there is something that I'm not doing right.

I've got two tables: Task and DefaultUser. Task has two columns: Name (Employee Name) and Task #. DefaultUser has two columns: Name (Employee Name) and UserEmail (Employee Email). There is a join between the two Name columns that is One-to-Many and a single cross filter direction where DefaultUser filters Task. I also created a calculation table in TabularEditor called UserDefault. The first calculation item is called "No", and the formula looks like this so that the table I create will have no filters:

NO = SELECTEDMEASURE ()

The second calcuation item is called Yes, and the formula looks this:

Once I create the table, I use the Name and Task # columns from the Task table. I added UseDefault to a slicer and "No" and "Yes" show as my options like they are supposed to. However, when I use PowerBi's "View As" function to view the table as someone with a different email and click "yes" to activate the filter, nothing happens. What is going wrong?

[some_bih]

Hi @K_demmons I am curios: first part of IF is for NOT (no) and second calculate amount?

Check part in first CALCULATE.