how can I create a measure similar to if statement of excel

[ligalbert]

I want to create a measure where if status is equal to 8 it should be 1 otherwise 0 

 

[ligalbert]

Worked Perfectly thank you 

[Seanan · Accepted solution]

Hi @ligalbert 

Could you please try this:

Value = IF(MAX('Values'[Values]) = 8,1,0)

Kind regards,
Seanan
If this post helped, please consider accepting it as the solution.