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 👍

DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
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 👍