cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jabelenoa
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.

 

Productos.png

 

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 =
SUMX (
VALUES ( 'Producción'[Production Date] ),
CALCULATE ( DISTINCTCOUNT ( 'Production'[Product type])-1 )
)
 
Thank you all for all the help you could provide!
 
2 REPLIES 2
Icey
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,

Icey

amitchandak
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

Announcements
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.