Forum Discussion
Distinct count based on date field and Presentation Used
Hi Experts Based on the sample data below i want to work out the number of time a presentation has been used over the distinctcount date value.. I believe the answer to the below is 3. Da...
Hi Anonymous
You can achieve this by using the following measure:
Measure = CALCULATE ( DISTINCTCOUNT ( 'Table'[Date] ) , ALLEXCEPT ( 'Table' ,'Table'[Presentation Name] ) )
It uses distinctount on the Date and filters out everything other than the Presentation Name.
A PBIX has been attached for additional assistance.
All the best!
Theo 🙂
Hi Anonymous
You can achieve this by using the following measure:
Measure = CALCULATE ( DISTINCTCOUNT ( 'Table'[Date] ) , ALLEXCEPT ( 'Table' ,'Table'[Presentation Name] ) )
It uses distinctount on the Date and filters out everything other than the Presentation Name.
A PBIX has been attached for additional assistance.
All the best!
Theo 🙂