Hi @KA95 ,
Please use the column from the date table "Dates" as the fields of table visual?
And measure like the following expression:
ALLSELECTED ( 'Candidate Activity' ),
YEAR ( 'Candidate Activity'[active_date] ) = SELECTEDVALUE ( Dates[year] )
&& MONTH ( 'Candidate Activity'[active_date] )
= SELECTEDVALUE ( Date[MonthNumber] )
Or you can share some example data and expect result if you need more help.
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.