Can a measure that uses CALCULATE and additional filtering, filter other visuals?

[D_PBI]

Hi,
I have the below measure.

That when I placed into a matrix returns several numbers as shown below.

There is also a table visual on the page that has the patentid and patentype fields present. It these same fields that are used in the measure. This table currently shows 1500 rows.
I would like to know if there is a way for the report user to click on the figure 448 (which is the 2023-24 figure) and then for that table visual to be filtered down to show just those 488 records?

I'm on the understanding that this isn't possible due to the measure using the CALCULATE function and having additional filtering. I understand that if the measure didn't use the CALCULATE function and didn't use additional filtering, and used something basic like a COUNT or SUM function on a single field, then this would be possible.
Please can someone confirm my understanding? Thanks.

[v-venuppu]

Hi @D_PBI ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu]

Hi @D_PBI ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-venuppu]

Hi @D_PBI ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Regards,

Rama U.

[lbendlin · Accepted solution]

Read about Drillthrough.  Then create a Drillthrough page that accepts the Financial Year filter.