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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Godi
New Member

Multiple OR functions as a measure

I have a table with 3 categories. Depending on the the first category (C1 - C35), the others require different data. Example

     C1 requires all three levels

     C2 requires only one level

     C3 requires no additional level

     ...

I do not have acces to the Power SQL table, consequently I need to to this as a DAX measure. OR function is limited to only two parameters, but in my case, I would need at least 3 OR queries,

 

Can anyone tell me, what to do?

 

Thanks.

1 ACCEPTED SOLUTION
eliasayyy
Memorable Member
Memorable Member

hello you can put an or inside an or for example

OR(first condition,
OR(Second  Condition,
OR(third Condition,
Fourth condition
    )
   )
)

View solution in original post

1 REPLY 1
eliasayyy
Memorable Member
Memorable Member

hello you can put an or inside an or for example

OR(first condition,
OR(Second  Condition,
OR(third Condition,
Fourth condition
    )
   )
)

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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