Forum Discussion

Jabelenoa's avatar
Jabelenoa
Regular Visitor
6 years ago

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

2 Replies

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Jabelenoa ,

     

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

     

     

    Best Regards,

    Icey