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 👍

Anonymous's avatar
Anonymous
Not applicable
3 years ago

 

Hello everyone, thanks for the answers, I wasn't very clear for what I wanted. I have problem with month depicting because i want data from both receipt ID and Delivery ID in one chart. In this situation i used a month-year, monthyear short table so i could depict in stacked column chart but it was no use. Stacked column chart depicts the same number for both receipt ID and Delivery ID. is there anything I could use to surpass this?