measure not filtering visuals when clicked

[abcttt233]

I have a measure like this:

Sum of ABC =

CALCULATE([Sum of ABC],'table'[nr] IN { "R" })

This measure is on a table. 

My expectatino is when I click on a value on the table for this measure, it filters other visuals to only show values which have a value of "R" - however this does not seem to be the case. I've tested that interactions are all fine by using a slicer with the column NR and everything updates apart from my measure. Is there any way I can change the measure so it flows to the other visuals? 

[Anonymous · Accepted solution]

Hi  @abcttt233 ,

As far as I know., interactions between visual objects do not pass the filters in the measure. The interaction between two visual objects is caused by fields in static columns (Group, ABC, Index, nr=), not by metrics. The measure values are calculated based on the current row context.

For example:

Table, you click on the meaure, and what you check is the condition of this whole row (Group=A, ABC=2, Index=2, nr=w), power bi will pass the condition of this whole row to the bar chart, and the bar chart will display the data according to this condition.

You can use nr as a slicer if you need visual to implement the nr=R condition.

Refer to:

Solved: drillthrough is not working with measure filters - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[PijushRoy]

Hi @abcttt233 

As per my Idea, use the measure as Text section in button or shape
Create a bookmark with Filter by R
Then apply the Bookmark in button/share action section


Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[abcttt233]

Is it not possible to just have this as a measure in power bI?

[nsexton12]

Have you checked your data model to ensure that the tables are linked properly? If that is good, could you please provide a few sample rows of data from your tables? It would be helpful so that we can recreate your measure and test potential solutions.

[abcttt233]

Still no luck

[PijushRoy]

Hi @abcttt233 

Can you share screenshot of the requirement

[abcttt233]

I don't have one, the other visual is another table of entries and i want that table of entries to be filtered for "R" values only, when the first visual has the measure clicked on