Forum Discussion
Use table filtered in var to filter the same table again
Hello,
I use the following dataset :
I first display this table with a filter on the manager selected and the date selected (this date has to be in the range Start Date - End Date) :
My goal is to display next to it the same table but solely filtered on the clients that are present in the table i showed above, and on another date I chose (Date 2). It would look like this :
So I tried to create a metric "GetClients" to filter the clients on my second table :
(Here [Active Dates 1] is the metric to filter the table based on the first date, so that I retrieve the table first table in my variable)
But when I aply it I don't have the result expected (ClientC shouldn't be there):
Is it a problem to first filter testTable in a variable and then use it to filter again testTable ?
Are there other solutions to get the clients of the first table?
Thanks
See attached.
4 Replies
- lbendlin
Super User
you need to use disconnected/shadow tables for that.
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.
If you are unsure how to do that please refer to 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.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hello lbendlin ,
Thank you very much for your answer, here is the link for a sample of my powerbi with the issue only (no sensitive data).
My expected outcome is dynamic as it depends on the table I filter on the left, I want to display in my right table the rows corresponding to the clients that appear in my left one (i've made a schema in the pbix).
Also I've looked into disconnected tables and shadow filters : my tables are already disconnected but it seems it is not related to the problem, and I don't really understand the concept of shadow filtering ...
- lbendlin
See attached.
