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"))

1 Reply

  • 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"))