Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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 IDCreation DateItemQTYDelivery IDDelivery DateReceipt IDReceipt Date
2600011/4/2023PS4149000122/4/202350000125/4/2023
2600011/4/2023PS2149000122/4/202350000125/4/2023
2600011/4/2023PS3149000122/4/202350000125/4/2023
2600011/4/2023PS1149000122/4/202350000125/4/2023
2600022/4/2023PS1149000223/4/202350000226/4/2023
2600022/4/2023PS3149000223/4/2023  
2600033/4/2023PS2149000324/4/2023  
2600044/4/2023PS3149000425/4/2023  
2600044/4/2023PS4149000425/4/2023  
2600055/4/2023PS4149000526/4/2023  
2600066/4/2023PS1149000627/4/2023  
2600077/4/2023PS2149000728/4/2023  
2600088/4/2023PS3149000829/4/2023  
2600099/4/2023PS4149000930/4/2023  

 

Problem is that distict count for column DeliveryID and Receipt ID comes as the same result. Any advices?

1 ACCEPTED SOLUTION
DOLEARY85
Resident Rockstar
Resident Rockstar

Hi,

 

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

 

Measure = DISTINCTCOUNT('Table'[Receipt ID])
 
Measure 5 = DISTINCTCOUNT('Table'[Delivery ID])
 
DOLEARY85_0-1681305302927.png

 

 

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

 

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
Super User
Super User

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

DOLEARY85
Resident Rockstar
Resident Rockstar

Hi,

 

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

 

Measure = DISTINCTCOUNT('Table'[Receipt ID])
 
Measure 5 = DISTINCTCOUNT('Table'[Delivery ID])
 
DOLEARY85_0-1681305302927.png

 

 

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.