Row Based Updated Column

shahzad667 — Tue, 25 Oct 2022 07:18:26 GMT

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"

Re: Row Based Updated Column

wdx223_Daniel — Tue, 25 Oct 2022 07:33:42 GMT

=IF(CALCULATE(DISTINCTCOUNT(Table[Shift]),ALLEXCEPT(Table,Table[EMPLID]))>1,"Both","Single")