filter on a table not directly related

[nicolast29]

Hi

I need to filter and show people how are still here at the day of a musical repetition, but there are no direct relation between the two table

My people can be in different Groupe

and i specify foe each repetition the group concern

so i try to make a mesure in order to filter people who are n the group of the reptition selected adn who are still here (whitout depart date)

But it is too diffcult for me

First selection of the repetition by selecting a date

Link:

Repetion Id with Groupe1 ID

AppartenanceGroupe 1 ID Group whith Groupe1 Id

Choriste1 Code with AppartenanceGroupe Id group

Here The report that i want 

but whitout people with a end date priora the date of the repetion

thanks

[Anonymous]

Hi @nicolast29 

I'd strongly recommend that you get familiar with this post: https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-...