Forum Discussion

Yogisha's avatar
Yogisha
Frequent Visitor
6 years ago
Solved

DAX Help

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 1Level 2Amount
ABC123100
DEF456200
GHI789300
JKL258400

 

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!

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Yogisha 

    Assume you have table

     

    Then view as "[email protected]"

     

    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.