Forum Discussion

nele's avatar
nele
Frequent Visitor
4 years ago
Solved

Distinctcount filtered by measure

Hi,   I want to use the following expression: Partners pos Delta = CALCULATE(DISTINCTCOUNT('Store Performance'[Customer Partner Name]),FILTER('Store Performance',[salesDelta]>0)) However, the ...
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    nele Try:

    Partners pos Data = 
  VAR __Table =
    FILTER(
      ADDCOLUMNS(
        SUMMARIZE('Store Performance',[Customer Partner Name]),
        "__salesDelta",[salesDelta]
      ),
      [__salesDelta]>0
    )
RETURN
  COUNTROWS(
    DISTINCT(
      SELECTCOLUMNS(__Table,"Customer Partner Name",[Customer Partner Name])
    )
  )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

nele Try:

Partners pos Data = 
  VAR __Table =
    FILTER(
      ADDCOLUMNS(
        SUMMARIZE('Store Performance',[Customer Partner Name]),
        "__salesDelta",[salesDelta]
      ),
      [__salesDelta]>0
    )
RETURN
  COUNTROWS(
    DISTINCT(
      SELECTCOLUMNS(__Table,"Customer Partner Name",[Customer Partner Name])
    )
  )
nele's avatar
nele
Frequent Visitor
4 years ago

Greg_Deckler , this works for 100%! Thank you so much!