Forum Discussion

MarkCBB's avatar
MarkCBB
Icon for Helper V rankHelper 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] = "PNP" or [CHANNEL] = "OMO"

 

the other one that I am trying to do is [CHANNEL] = ("PNP or [CHANNEL] = "OMO") and ([REGION] = "R1" or [REGION] = "R2")

 

But I cant find the correct syntax to do this, has anyone been able to do something similar?

 

2 Replies

  • MarkCBB's avatar
    MarkCBB
    Icon for Helper V rankHelper 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
      Icon for Advocate I rankAdvocate 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")
      )