Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DistinicCountNoBlank Function (Need help excluding a value from the count)

Can I add something to a DistinicCountNoBlank measure to have it not count the word "Unique" ?   # SJD Products = DISTINCTCOUNTNOBLANK('ALL POS'[SJD #])   Thanks in advance.
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

    # SJD Products = calculate(DISTINCTCOUNTNOBLANK('ALL POS'[SJD #]), filter('ALL POS','ALL POS'[SJD #] <> "Unique"))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try like

# SJD Products = calculate(DISTINCTCOUNTNOBLANK('ALL POS'[SJD #]), filter('ALL POS','ALL POS'[SJD #] <> "Unique"))