Forum Discussion

Godi's avatar
Godi
New Member
3 years ago
Solved

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.

  • eliasayyy's avatar
    eliasayyy
    3 years ago

    hello you can put an or inside an or for example

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

1 Reply

  • eliasayyy's avatar
    eliasayyy
    Icon for Memorable Member rankMemorable Member
    3 years ago

    hello you can put an or inside an or for example

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