topic Re: Remove Filter Context from Table Visual when Matrix is clicked in DAX Commands and Tips

Remove Filter Context from Table Visual when Matrix is clicked

Pmasuch — Thu, 24 Aug 2023 10:31:24 GMT

Hey there,

I have a matrix visual with the columns "destination" and "order number".
The destination is the first row and the order number the second.

When I open the matrix in one destination, all order numbers are shown. But order numbers could also be placed on another destinations. My aim is to create another visual as a table, where the other destinations of the clicked order number in the matrix are shown.

I think I have to create a special measure for the table visual, where the filter context is deleted. I tried, but with no success.

Could somebody help me?

Thanks and much greetings.

Re: Remove Filter Context from Table Visual when Matrix is clicked

lbendlin — Fri, 25 Aug 2023 22:38:53 GMT

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Remove Filter Context from Table Visual when Matrix is clicked

Pmasuch — Sat, 26 Aug 2023 10:13:50 GMT

Hi lbendlin ,
I have created a simple spreadsheet and a pbix file to explain my aim.

Hopefully, everything is clear now.

Example.pbix

Thank you!

Re: Remove Filter Context from Table Visual when Matrix is clicked

lbendlin — Sat, 26 Aug 2023 12:10:26 GMT

You need to use a shadow copy of your table to do that

see attached

Re: Remove Filter Context from Table Visual when Matrix is clicked

Pmasuch — Sat, 26 Aug 2023 12:40:07 GMT

Thank you lbendlin
Is this a possible way for Tabular Editor 3, too? Or is there any other opportunity?

Re: Remove Filter Context from Table Visual when Matrix is clicked

lbendlin — Sat, 26 Aug 2023 12:54:14 GMT

Not sure where the connection is. This is about focus and filter context, not about calculation groups.

Re: Remove Filter Context from Table Visual when Matrix is clicked

Pmasuch — Sat, 26 Aug 2023 12:56:38 GMT

Is there any opportunity to create a measure for the table visual, that ignores the filter context from the matrix with creating a "shadow table"? I tried your solution with tab editor, it doesn't work 😕

Re: Remove Filter Context from Table Visual when Matrix is clicked

lbendlin — Sat, 26 Aug 2023 16:08:22 GMT

you lost me there. I still don't know what that would have to do with Tabular editor.

Re: Remove Filter Context from Table Visual when Matrix is clicked

Pmasuch — Sat, 26 Aug 2023 18:39:46 GMT

To duplicate the table doesn't worked for this problem.
I'm working with own created dataflows, so I have created a new dataflow with the necessary data, almost a duplicate but a little bit smaller.

Now it works. Thank you very much!