Solved: Distinct count based on date field and Presentatio...

Anonymous · ‎05-06-2022

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.

Date	Presentation Name
01/01/2022	Presentation 1
01/01/2022	Presentation 1
01/02/2022	Presentation 1
01/02/2022	Presentation 1
01/02/2022	Presentation 1
01/03/2022	Presentation 1
01/03/2022	Presentation 1

TheoC · ‎05-09-2022

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 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

TheoC · ‎05-09-2022