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.
I have a table called bookings, and a table called persons. I want to calculate how many different persons have gotten a booking within some time interval.
Bookings:
id | Date | personId |
1 | 01-03-2022 | 1 |
2 | 02-03-2022 | 1 |
3 | 03-03-2022 | 2 |
4 | 04-03-2022 | 3 |
Persons:
id |
1 |
2 |
3 |
4 |
I want to know how many bookings each person has had, which I calculate by:
total bookings = DISTINCTCOUNT('booking'[id])
I can display this in the persons table, and see that it works right.
And I then calculate how many unique persons have gotten a booking by:
Persons with bookings =
CALCULATE(
COUNTROWS('persons)'),
FILTER('persons', 'persons'[total bookings] > 0)
)
When I set a slicer to march 2022, I expect to see:
But on 'total bookings' is calculated proberly. And I can't seem take get 'Persons with bookings' right. At the moment it simply returns (Blank) for each of the persons rows.
Solved! Go to Solution.
Hi,
you have confused the two Table.
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Hi @FrederikB ,
You can create measures like this to get the result:
total bookings = DISTINCTCOUNT('bookings'[id])
Persons with bookings =
VAR tab =
SUMMARIZE (
'bookings',
'bookings'[personId],
"total bookings", [total bookings]
)
RETURN
COUNTX ( tab, [personId] )
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply, but I am not sure that I either understand what you mean, or that the provdided solution solves the problem.
It seems like 'Persons with bookings' is summed to four, even though only 3 unique persons have gotten a booking.
Hi @FrederikB ,
You can create measures like this to get the result:
total bookings = DISTINCTCOUNT('bookings'[id])
Persons with bookings =
VAR tab =
SUMMARIZE (
'bookings',
'bookings'[personId],
"total bookings", [total bookings]
)
RETURN
COUNTX ( tab, [personId] )
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
you have confused the two Table.
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Check out the July 2025 Power BI update to learn about new features.