Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
MarkCBB
Helper V
Helper V

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 2
MarkCBB
Helper V
Helper V

 

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

 

still struggleing with the other one

 

 

 

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")
)

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors