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.
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.