Filter data with dynamic segmentation

Hi v-huizhn-msft

Yes, That's exatcly what i want.

Let me explain how i did the measure:

First, i have a oracle database that i have all information about these sites, but i dont have a head count for the employees that i need. So, i have another source, but in Excel file with this data. In this Excel i made these formula to calculate the head count:

Calculate total of effective employees

Colaboradores efetivos total = SUM(DataBI2_RMensal[Nº de funcionários efetivos]

Calculate total of third-part employees

Colaboradores temporarios total = SUM(DataBI2_RMensal[Nº de funcionários temporarios])

And calculate the total of employees (effectives and third-part) for the sites.

HEAD TOTAL = CALCULATE(DataBI2_RMensal[Colabres efetiv-ios total] + DataBI2_RMensal[colabores temporarios total])

Then, i made a relationship between my site_id in my oracle database and my excel file (TB_PIRAMIDE = oracle dabatase and DataBI2_RMensal = excel file), like this:

 And so i wondered that if i put in dynamic segmentation the sites, these would be filtered with the head total by site like the previous images.

So far, i dont understand how can i affect the card visual by interactions under modeling, could you give some example?

I tought that if i made a relationship between these tables all the data would be filtered.

Thanks in advance.