Forum Discussion

MarkCBB's avatar
MarkCBB
Helper V
10 years ago

RLS DAX Syntax for OR/AND

Hello,   I am messing around with the RLS on PowerBi.com, I can get simple DAX to work i.e. [CHANNEL] = "PNP"   But I would like to create the ability for a user to see 2 CHANNEL. i.e. [CHANNEL] ...
MarkCBB's avatar
MarkCBB
Helper V
10 years ago

 

ok, I was able to get the one working, OR([CHANNE] = "PNP",[CHANNEL] = "OMO"

 

still struggleing with the other one

 

 

 

  • elRonaldo's avatar
    elRonaldo
    Advocate I
    10 years ago

    I know, your message is a little older, but perhaps it helps someone else...

     

    For the problem with [CHANNEL] = ("PNP or [CHANNEL] = "OMO") and ([REGION] = "R1" or [REGION] = "R2")

     

    Did you try

     

    AND(
    OR([CHANNNEL]="PNP",[CHANNEL] = "OMO"),
    OR([REGION]="R1",[REGION] = "R2")
    )