Problem with distict count

[Anonymous]

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?

[Anonymous]

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?

[FreemanZ]

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

[DOLEARY85 · Accepted solution]

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 👍