Please find the attached screenshot. I want a DAX formula that should assign a value of 1 to the first occurrence of each unique value in the "UBID" column of the "DSRReport" table, and 0 to subsequent occurrences of the same value.
In Excel, I used the following formula to get the result'=IF(COUNTIF($A$1:A2,[@UBID])>1,0,1)', but I am unable to get it in DAX. Please help me with this. Thanks in advance.
![1711544303331.png 1711544303331.png](https://chandoo.org/forum/data/attachments/86/86990-6792af52d38312fd46cad3871ff8193a.jpg)
In Excel, I used the following formula to get the result'=IF(COUNTIF($A$1:A2,[@UBID])>1,0,1)', but I am unable to get it in DAX. Please help me with this. Thanks in advance.
![1711544303331.png 1711544303331.png](https://chandoo.org/forum/data/attachments/86/86990-6792af52d38312fd46cad3871ff8193a.jpg)