topic Re: Table Filtering in DAX Commands and Tips

Table Filtering

BA11501Banderso — Thu, 10 Feb 2022 20:26:24 GMT

I have a table with a long list of accounts and changes in those accounts from the prior month. I have a second table I'd like to have show the monthly totals for the past two years for the account clicked on in the first table. The problem I am having is when I click on the account in the first table, I'm only able to see the one month referenced in the first table in the second. The point of the first table is to highlight outliers. The point of the second table is to see how big of an issue it is in relation to the previous months.

Re: Table Filtering

Whitewater100 — Thu, 10 Feb 2022 22:06:00 GMT

Hi:

This would be a nice one to do dril-through on. If you build your second detailed table with all the coulmns you want on another page, you can drop the Acct No field into this new detailed second page where it says drill-thru fields. Then when a user R-clicks your first account list at a high level they can see all the details on your drill-thru page. Just one idea.

To answer your question it should work. You can go to Format-Edit Interactions and choose the filtering style (or not) but normally that column should filter other visuals. Hope this gives you an option to explore.

Re: Table Filtering

BA11501Banderso — Mon, 14 Feb 2022 17:32:35 GMT

Thank you Whitewater100. It did work. The issue that was keeping me from having the interactions work correctly is I had a date filtered.