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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Super User
Super User

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
Super User
Super User

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors