Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Problem with distict count

Greetings,   I have a table that I want to make distict count but does not work as I want:   Table:   Creation ID Creation Date Item QTY Delivery ID Delivery Date Receipt ID Receipt D...
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi,

     

    i used the data here with these 2 measures and it works:

     

    Measure = DISTINCTCOUNT('Table'[Receipt ID])
     
    Measure 5 = DISTINCTCOUNT('Table'[Delivery ID])
     

     

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

how many do you get for each from the sample data?