Forum Discussion
Solved
Row Based Updated Column
i want the desired column in dax calculated column or measure on my data i want to write dax to show my desire result as if a person have assigned day and night sift so it shows both on...
=IF(CALCULATE(DISTINCTCOUNT(Table[Shift]),ALLEXCEPT(Table,Table[EMPLID]))>1,"Both","Single")
=IF(CALCULATE(DISTINCTCOUNT(Table[Shift]),ALLEXCEPT(Table,Table[EMPLID]))>1,"Both","Single")