@DRNEWTR Try:
Measure =
VAR __Table =
DISTINCT(
SELECTCOLUMNS('DATA',"STORE",[STORE],"ORDER NUMBER",[ORDERNUMBER],"PERSON",[PERSON])
)
RETURN
SUMX(__Table,[PERSON])
@DRNEWTR Try:
Measure =
VAR __Table =
DISTINCT(
SELECTCOLUMNS('DATA',"STORE",[STORE],"ORDER NUMBER",[ORDERNUMBER],"PERSON",[PERSON])
)
RETURN
SUMX(__Table,[PERSON])
Thank You So Much.