Forum Discussion
Distinct Count of Two Columns
Hello all,
I have a Booking Table where I have a Booking ID and a Departure ID for each booking.
I need a measure to calculate the no. of legs which should be the Distinct Depature ID for each Booking ID.
Anonymous , Try with Departure id?
COUNTROWS(SUMMARIZE(Booking, Booking[Booking Reference], Booking[Departure ID]))
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi Anonymous ,
My sample data is this
The measure
DistinctCount = CALCULATE ( DISTINCTCOUNT ( 'Booking Table'[Booking ID] ), ALLEXCEPT ( 'Booking Table', 'Booking Table'[Departure ID] ) )You can check details from the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous , Try with Departure id?
COUNTROWS(SUMMARIZE(Booking, Booking[Booking Reference], Booking[Departure ID]))
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi Anonymous ,
My sample data is this
The measure
DistinctCount = CALCULATE ( DISTINCTCOUNT ( 'Booking Table'[Booking ID] ), ALLEXCEPT ( 'Booking Table', 'Booking Table'[Departure ID] ) )You can check details from the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.