Forum Discussion
Conditional Statement
Hi, Does anyone knows of a function to solve this problem? I want to write a conditional statement with DAX. The problem is "if there are more than 2 number "5", then ..." Would appreciate if yo...
Hi Anonymous ,
you can create this calculated column:
More than 2 "5" = IF('Facts36'[Value1] =5 &&'Facts36'[Value2]=5 && 'Facts36'[Value3] =5,"Yes")and then you can filter the table for "Yes"If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mangaus1111
Solution Sage
Solution SageHi Anonymous ,
what do you mean by more than 2 numbers?
Something like this
| James | 5 | 5 | 5 |
| Lucas | 3 | 3 | 1 |
For example, James' row has the value "5" more than 2.