Multiple OR functions as a measure

Godi — Mon, 08 May 2023 05:56:27 GMT

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.

Re: Multiple OR functions as a measure

eliasayyy — Mon, 08 May 2023 06:22:10 GMT

hello you can put an or inside an or for example

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

topic Multiple OR functions as a measure in DAX Commands and Tips

Multiple OR functions as a measure

Re: Multiple OR functions as a measure