Hi @bapt69 ,
Perhaps you can refer to the following code, but the following code may not fully achieve the effect you want, I have a few questions can provide a specific reference:
1.Is your date table used for slicer filtering?
2.The conditions you provide are date_debut> date_fin, but the date_fin in the picture are greater than date_debut, whether it is only partially displayed
3.If date is used as a filter, it is recommended here that measures should be used instead of calculated columns
var a=COUNTAX(RELATEDTABLE('Table (2)'),[staus_club])
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.