Forum Discussion

sebastanaka's avatar
sebastanaka
Frequent Visitor
1 year ago
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 ...
Need Help
  • PBIViz_2024's avatar
    PBIViz_2024
    1 year ago

    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,

     

sebastanaka's avatar
sebastanaka
Frequent Visitor
1 year ago

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.

PBIViz_2024's avatar
PBIViz_2024
Advocate I
1 year ago

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,