Take unique value

[ChiRomeu]

Dear member,

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

 I would like to get this result:

Best regards

Chi

[v-mengzhu-msft · Accepted solution]

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.

[ChiRomeu]

For DAX in Power BI