Forum Discussion
Solved
Make a table ignore a specific filter
Hello, Thanks for helping. I have three tables in my sheet. The first breaks down the top items in the current week that were not sold, the items are distinguished by an item id. The second goes ...
Thanks for your input,
I tried this, and I already have the filter set up this way however it just leaves the 3rd table blank when clicking on a specific item on the 1st table.
Hi ,
If this is what you have looking for ,You can achive this by creating two measures.
once you click on the item on the first table 2nd table will filter to show the locations of respective items and third table shows the last week qty of the selected item.
Please check the attached PBIX for more info.Two solutions were given.Hope this works.
Regards,