Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

How can I find connected values?

Hi,

 

I have a bit of a difficult question: In our company, we operate a booking business, where each customer is registered as a "user". These users all have a distinct user id. For bookings, we have a "booking id" each time a user books an hours. 

 

What I want to find out is how many bookings we have per user. Can someone help me figure out a "good" way to do this. Both the "Bookings ID" column and "User ID" column is in the same table. So I am trying to figure out how many bookings we have per user ID (so the average of this, which I can build later by using visualizations). 

 

Can someone assist me with writing a smart expression or method to "connect" bookings id and user id, in order to see how many bookings id there is per user id? 

 

Really hoping someone can help as I am not sure how I would do this in Power BI

 

Thanks

1 ACCEPTED SOLUTION

Hi @Anonymous,

 

Check details as below:

Create a measure as below:

Measure = COUNT('Table'[Booking Id])

And you will see:

v-kelly-msft_0-1622186754238.png

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

 

View solution in original post

3 REPLIES 3
PaulDBrown
Community Champion
Community Champion

Create a measure:

bookings = COUNT ( Table [booking ID])

and then create a visual using the field user id and the measure





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

Hi and thank you for the follow up and quick response. 

 

I am not quite sure still - what type of visualization and what do you mean by "field user id"?

 

Thank you again!

Hi @Anonymous,

 

Check details as below:

Create a measure as below:

Measure = COUNT('Table'[Booking Id])

And you will see:

v-kelly-msft_0-1622186754238.png

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.