How to display one table input to other table output.

[arun3039]

I have a Db like Ticket reservation, from that i want to display (Table Visual) all the details of the users who booked tickets &  confirmed Tickets using confirmation_Id. In other Table Visual i want to display only details of the perticular user(How many persons are travelling with that confirmation_Id) who booked tickets.

If i select or click confirmation_id in first table visual, i should get all his details in second visual table.(eg family is going for vacation, Booked tickets with his name, & need to display details of others in other table)

[amitchandak]

@arun3039 , If the tables are already connected, then that should filter the other visual

Otherwise have measures like this of use in the visual level filter 

Meausre =

var _booking = values(booking[ID])

return

calculate(count(Reservation[ID]), filter(Reservation, Reservation[booking_id] in _booking) )

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[arun3039]

Sample Data like this 

Booking_Id	Name	Category	Adults	Child	Infant	Date	Total Amount
1	ABC	ZZ	1	1	0	10/7/2022	200
2	DEF	SS	2	0	1	10/7/2022	300
3	EHG	HG	3	0	0	10/7/2022	300
4	CCC	IT	1	0	0	10/7/2022	200
5	DDD	ZZ	2	0	0	10/7/2022	200

If he select Id 1 below table should display like this - 1 adult details & 1  child Details

Booking_Id	Name	Date	Service	Quantity
1	ABC	10/7/2022	Breakfast	1
1	XYZ	10/7/2022	Dinner	2

[v-jayw-msft]

Hi @arun3039 ,

The sample data you shared is not clear enough.
I didn't see the confirmation_Id you mentioned above and does the same booking id mean they are family?

Best Regards,

Jay