Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello!
Hoping someone can help with the DAX formula I need. I've been searching and trying, but I just cannot seem to get it right.
I unpivoted a table of appointments and now have several hundred "duplicate" appointments. I need to know a count of total appointments that I will use as a measure on several visualizations. Since people can come more than once, distinct count does not work for this case. I essentially am hoping for a measure that says, if "person name" and "date of appointment" are the same, view that as 1 value. For the table value below, I would hope that the measure would return a value of 3.
Person Name | Date of Appointment |
Person 1 | June 1 |
Person 1 | June 1 |
Person 1 | June 1 |
Person 2 | June 1 |
Person 2 | June 1 |
Person 1 | June 3 |
Person 1 | June 3 |
Thanks!
Solved! Go to Solution.
You can try this one, replacing Table with your actual table name
NewMeasure = COUNTROWS(SUMMARIZE(Table, Table[Person Name], Table[Date of Appointment}))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You can try this one, replacing Table with your actual table name
NewMeasure = COUNTROWS(SUMMARIZE(Table, Table[Person Name], Table[Date of Appointment}))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
This seemed to work! Thanks! I also realized I could concatenate the two columns and then create a measure of distinct values on that column.
Thanks again!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |