Power BI Dynamic RLS Practice with Answer Key

Suppose we are sending the Blinkit Maharashtra report to three managers. Use the six orders from the DAX practice (13: Practice and Answer Key) plus this table (fictional e-mails).

User Security

Exercise (one under the other):

1. Enter User Security with Home › Enter data. Do not relate it to anything.
2. Modeling › Manage roles › New. Name: City Manager. Table: Orders (in this tiny model City is on Orders).
3. Paste the rule from the answer key. Save.
4. Modeling › View as › tick Other user › type each e-mail › tick City Manager.
5. Write down the Total Sales card for each user.

Expected result:

[City]
    IN CALCULATETABLE(
        VALUES('User Security'[City]),
        'User Security'[Email] = USERPRINCIPALNAME()
    )

Common mistakes:

Samajla ka? Test three people: one city, two cities, and nobody. If all three are right, the role is right.