Forum Discussion
Helper IIIFilter column, ignore visual filter
Hi guys,
I'd like to create a column of an existing column that ignores visual filter when I select a text value. In this example, each table of accounts has a visual filter. The left table is filtered by category = finished, right table by category = done.
When I click on Account = A on the left table, the right table shows no values due to the different visual filtering of both tables.
What I'd like to achieve, is that the right table still shows Account = A.
How can I create a new column of Account, that ignores the visual filter of the field Category?
Thank you.
Hi thhmez7,
A workaround to achieve this. Let the table visual one of them have all the catagroy. Then create a table to copy the Account column of origianl table. Use this copy account column as the column of table visual. The purpose of this step is to remove the effect of the Finished table on the done table, then we create a measure to get a selection of the finished table.
if_in = IF(SELECTEDVALUE('Table 2'[Account]) in VALUES('Table'[Account]),1)Then put the measure in visual level filter and set show itmes is 1.If you have some expression to calculated. You need modify the context of these measures. Add filter on these measure as the following example.
Measure for finished =CALCULATE([Measure],'Table'[Account]=SELECTEDVALUE('Table 2'[Account]),'Table'[Category]="done")The pbix file in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- amitchandak
Super User
thhmez7 , If you want to ingore the visual level filter why there is a filter. You can stop ineractions between two tables if needed
or create a measure with all or removefilters to ignore filter
https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak
thhmez7Can you post an example of creating a measure with all or removefilters regarding my case?
Basically I'd want:
I don't want to calculate.
- amitchandak
thhmez7 , example measures
calculate(count(Table[Account]), all(Table[Category]))
or
calculate(count(Table[Account]), removefiltes(Table[Category]) )
Use with Account in visual
- v-chenwuz-msft
Community Support
Hi thhmez7,
A workaround to achieve this. Let the table visual one of them have all the catagroy. Then create a table to copy the Account column of origianl table. Use this copy account column as the column of table visual. The purpose of this step is to remove the effect of the Finished table on the done table, then we create a measure to get a selection of the finished table.
if_in = IF(SELECTEDVALUE('Table 2'[Account]) in VALUES('Table'[Account]),1)Then put the measure in visual level filter and set show itmes is 1.If you have some expression to calculated. You need modify the context of these measures. Add filter on these measure as the following example.
Measure for finished =CALCULATE([Measure],'Table'[Account]=SELECTEDVALUE('Table 2'[Account]),'Table'[Category]="done")The pbix file in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
