DAX Help

[Yogisha]

Hi Folks,

Need help on DAX. I have a requirement where I have to apply below condition on a table.

[Level 1] = userprincipalname()

Data:

Level 1	Level 2	Amount
ABC	123	100
DEF	456	200
GHI	789	300
JKL	258	400

And need to ignore the above-mentioned condition when Level 2 user is logged in.

Example : If a user from Level 1 logs in then need to show the amount for that user only. If a user from Level 2 logs in then need to show all the Amount with level 2 info - without any filter. 

Thanks in advance!

[v-juanli-msft · Accepted solution]

Hi @Yogisha 

Assume you have table

Then view as "a@microsoft.com"

Then view as "b@microsoft.com"

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Can same user exist in both Level 1 and Level 2?

[Yogisha]

Yes..can exist