Forum Discussion
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 Date |
| 260001 | 1/4/2023 | PS4 | 1 | 490001 | 22/4/2023 | 500001 | 25/4/2023 |
| 260001 | 1/4/2023 | PS2 | 1 | 490001 | 22/4/2023 | 500001 | 25/4/2023 |
| 260001 | 1/4/2023 | PS3 | 1 | 490001 | 22/4/2023 | 500001 | 25/4/2023 |
| 260001 | 1/4/2023 | PS1 | 1 | 490001 | 22/4/2023 | 500001 | 25/4/2023 |
| 260002 | 2/4/2023 | PS1 | 1 | 490002 | 23/4/2023 | 500002 | 26/4/2023 |
| 260002 | 2/4/2023 | PS3 | 1 | 490002 | 23/4/2023 | ||
| 260003 | 3/4/2023 | PS2 | 1 | 490003 | 24/4/2023 | ||
| 260004 | 4/4/2023 | PS3 | 1 | 490004 | 25/4/2023 | ||
| 260004 | 4/4/2023 | PS4 | 1 | 490004 | 25/4/2023 | ||
| 260005 | 5/4/2023 | PS4 | 1 | 490005 | 26/4/2023 | ||
| 260006 | 6/4/2023 | PS1 | 1 | 490006 | 27/4/2023 | ||
| 260007 | 7/4/2023 | PS2 | 1 | 490007 | 28/4/2023 | ||
| 260008 | 8/4/2023 | PS3 | 1 | 490008 | 29/4/2023 | ||
| 260009 | 9/4/2023 | PS4 | 1 | 490009 | 30/4/2023 |
Problem is that distict count for column DeliveryID and Receipt ID comes as the same result. Any advices?
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 👍
3 Replies
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 👍
how many do you get for each from the sample data?
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?
