Forum Discussion
Solved
Limiting data on different levels
I have item/purchase order level data in a single query. I want to be able to select a single item from the top table, and have it show me all of the items that are on that same PO. I got it to wor...
As soon as they clicked on that single line you will need two separate copies of your data. One that is impacted directly by the filter context (user choices) and another that is disconnected, and controlled by measure filters.
As soon as they clicked on that single line you will need two separate copies of your data. One that is impacted directly by the filter context (user choices) and another that is disconnected, and controlled by measure filters.
That's how I got it to work, I was hoping for a better solution than having to load that data twice since it's in the 200k row range. Thank you!