Solved: Re: Conditional Statement

Anonymous · ‎10-24-2022

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 you guys help me, Thanks!

mangaus1111 · ‎10-24-2022

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 · ‎10-24-2022

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 · ‎10-24-2022

Is your table like table A or Table B? Which is your expexted result?

Anonymous · ‎10-24-2022

I have table A just like u created. I want to transform my table A to

I only want to display names who has the value "5" more than twice.

mangaus1111 · ‎10-24-2022

Hi @Anonymous ,

what do you mean by more than 2 numbers?

Something like this

Anonymous · ‎10-24-2022

James

5

Lucas

3

1

For example, James' row has the value "5" more than 2.

Conditional Statement