Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Distinct count different products and dates

Hello to everyone!


This is my first post in this community. I have read your previous threads and have been quite helpful in learning this tool.




These are different products done on different dates. I want count how many Changeover I did have in this month.


The real number should be 4, a CO on the 1, 3, 11 and 28.


I have been able to count the CO when they happen in the same day, but when they happen from one day to another (10 ->11 and 27->28) the formula I am using is not working.


To distinct count I am using:


CO =
VALUES ( 'Producción'[Production Date] ),
CALCULATE ( DISTINCTCOUNT ( 'Production'[Product type])-1 )
Thank you all for all the help you could provide!
Community Support
Community Support

Hi @Jabelenoa ,


Please share me a dummy PBIX file or just some sample data, removing sensitive information, for specific test.



Best Regards,


Super User IV
Super User IV

@Jabelenoa ,Can you share sample data and sample output.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.