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 column and if a person only assing day or night shift show value "Single"
=IF(CALCULATE(DISTINCTCOUNT(Table[Shift]),ALLEXCEPT(Table,Table[EMPLID]))>1,"Both","Single")
1 Reply
=IF(CALCULATE(DISTINCTCOUNT(Table[Shift]),ALLEXCEPT(Table,Table[EMPLID]))>1,"Both","Single")