Forum Discussion

ChiRomeu's avatar
ChiRomeu
Helper I
3 years ago
Solved

Take unique value

Dear member,

 could you please kindly help me to solve the following problem:

 I would like to get this result:

Best regards

Chi

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi ChiRomeu ,

     

    According to your description, you should want to complete an operation like if determination, in power bi, also using the if function, similar to the way I have written as shown in the image:

    unique value = IF(SELECTEDVALUE('Table'[column1 ])>5,0,1)

     

    Note that this is not a specific answer, and due to the lack of sample data, I am providing it to you for reference.
    But to achieve your goal, using the if function is obviously appropriate, for more details you can refer to this link:

    IF function (DAX) - DAX | Microsoft Docs

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi ChiRomeu ,

     

    According to your description, you should want to complete an operation like if determination, in power bi, also using the if function, similar to the way I have written as shown in the image:

    unique value = IF(SELECTEDVALUE('Table'[column1 ])>5,0,1)

     

    Note that this is not a specific answer, and due to the lack of sample data, I am providing it to you for reference.
    But to achieve your goal, using the if function is obviously appropriate, for more details you can refer to this link:

    IF function (DAX) - DAX | Microsoft Docs

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.