Using Slicer (Year) to to filter card measure and table first. Then measure to filter table

[m4amin]

Hello members,

I am stuck in some DAX logic and need your help.

1. I have two slicers (Year = 2019, 2020, 2021) and (Cycle = September, March).
2. I have three calculated measures showing on separate cards
3. Finally, I have a table that will filter based on the slicer and the card measure

What I would like to happen is based on the year filter and cycle filter (single selection enabled), the card measure and year would get filtered. I would then like to click on the card measure to then show me ONLY those records in the table that are relevant to the card measure. Is this possible?

Here is how far I have gotten. I have the year and cycle slicer configured so that the card measure and table is filtered for a specific year and cycle. I have also gotten to the point where the card measure is filtering the table (I put a rectangle shape around the card measure value and created a bookmark on the table). When I select the card measure to filter the table, I go back to the year and cycle that I had originally bookmarked. It is not working for other years and cycle.

Any help is appreciated.

Thank you,

[amitchandak]

@m4amin , click on card will nor drill down or drill through.

There is work around, see if that can help - https://www.youtube.com/watch?v=VBRUiGeV6I4

[m4amin]

Thank you @amitchandak but I have applied this technique using the rectangle feature on my card which successfully drills/filters the table.

I am stuck on the ability to drill/filter based on the selection of the card while switching back and forth between the two slicers I have (year an cycle) which drills/filters the card measures and the table. Still no workaround yet.