Select a single cell in table

Hello MFelix ,

Apologies for getting back to you delayed, I was occupied.

I tried your solution and I was able to select individual cell rather than a whole row but still the problem did not solved.

From the above figure you can see matrix visual on the top and a normal table below. The idea here is if I click on any particular cell on the first table it must filter in second table. For example if I click "3" in the 9th ID of Last week - Forecast only 3 records must be shown in the bottom table.

From the second image now you can notice that I have selected value "3" in Last week - Forecast of ID 9. But lot of records are selected (ID 9 = Award), its still filtering based on the ID rather than showing individual results.

The measures in the first table "Last week - Forecast" and "Last Week - Plan" are indiviual DAX. It is just filtering data based on dates so I am pretty much not sure how to achieve this. Do I need to create a relationship table, please advise.

You have helped a lot but need this query to be resolved.

Thanks,

Karthik