Filter with pivoted data doubt

Hi!

I need help with the best way of filtering my data with slicers 🙂

I have attached the data of two tables in a link at the end of this post. The first table has some operational and costs information of different travels that happened during 2021. I have the month it occurred, number of passengers, the time duration and the cost of this travel in the first table.

The second table I have some information of cost allocation for each travel among three different cost centers (CC1, CC2 and CC3). This happens because the costs of the travel depends on which cost center each passenger belongs. For example, if a travel has 5 out of 10 passengers from CC1, 3 from CC2 and 2 from CC3, then the costs will be distributed as 50%, 30% and 20%, respectively.

When building my dashboard in powerbi, I would like to be able to apply a slicer of the cost centers.

For instance, imagine I create a measure of Total Passengers = SUMX('Table 1', 'Table 1'[Passengers]'). Also, imagine I would create a relationship between Table 1 and Table 2 for the "Travel" column.

What would be the best way to apply a slicer of the cost center, so that if I select CC1, I see the total passengers from CC1 have been transported? So if I select CC1 and CC2, it shows the sum of those two cost centers passengers?

I have some toughts on using SELECTEDVALUE, but I don't like this idea as it would make very complex if I had dozens of cost centers.. 

Anyway, I would appreciate a lot your help. 🙂  The example data is in this link: Example Data

Happy new year!