Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
@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.