Year-Month Specific Goal # (Want to Bring to Card)

[YavuzDuran]

Hi All,

I have a goal table in which goals may vary for each month. 

I put a relationship between this goal table and my Calendar Table.

When I want to select year and month I want to see that month's Goal in the card I created.

For 2021Oct = 75, for 2021Sep = 65, but #Goal is not changing (Sep Goal is %65)

Am I missing something 

Can someone help me 

[YavuzDuran]

Bridge Table helped me. Thank you 

[PaulDBrown · Accepted solution]

The relationship between the Calendar Table and the Agent Collection Goals is many-to-one and in the wrong direction. A solution is to create a bridge table with unique values for YearMonth and the corresponding year and month columns to use as the slicer. You can then create one-to-many & one-to-one single direction relationships between the bridge  table and the Calendar and Agent Collection Goals tables respectively.

As an alternative, you can delete the relationship between the calendar table and the Agent Collection Goals table and use a measure using TREATAS to return the goal keeping the slicer from the calendar table.