Distinct count different products and dates

[Jabelenoa]

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 =

SUMX (

VALUES ( 'Producción'[Production Date] ),

CALCULATE ( DISTINCTCOUNT ( 'Production'[Product type])-1 )

)

Thank you all for all the help you could provide!

[Icey]

Hi @Jabelenoa ,

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

Best Regards,

Icey

[amitchandak]

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