Distinc sum group by multı colum

[DRNEWTR]

Hi,

I need sum distinc by group

[Greg_Deckler · Accepted solution]

@DRNEWTR Try:

Measure =
  VAR __Table = 
    DISTINCT(
      SELECTCOLUMNS('DATA',"STORE",[STORE],"ORDER NUMBER",[ORDERNUMBER],"PERSON",[PERSON])
    )
RETURN
  SUMX(__Table,[PERSON])

[DRNEWTR]

Thank You So Much.