Forum Discussion
Filtering a table based on values from an unrelated table
Hi dparkinson,
Based on my test, you should be able to use the formula below to create a new measure first, then use it as visual level filter(Measure is greater than 0) to get the expected result in your scenario. :smileyhappy:
Measure = COUNTROWS ( FILTER ( TechCompanies, SEARCH ( TechCompanies[techcode], MAX ( Things[Thing Companies] ),, 0 ) > 0 ) )Here is the sample pbix file for your reference. :smileyhappy:
Regards
Hi dparkinson,
Based on my test, you should be able to use the formula below to create a new measure first, then use it as visual level filter(Measure is greater than 0) to get the expected result in your scenario. :smileyhappy:
Measure =
COUNTROWS (
FILTER (
TechCompanies,
SEARCH ( TechCompanies[techcode], MAX ( Things[Thing Companies] ),, 0 ) > 0
)
)
Here is the sample pbix file for your reference. :smileyhappy:
Regards
Thank you so much. I was facing a similar problem of filtering with a non related table. Now, after creating a measure, it is working. Thanks a lot again.
This worked for me until I tried to aggregate. I am trying to make an easy way to filter some parts of reports with a different date. For example part of the report using an entire year another part I want to be a variable date range. I used the measure technique to match against another date table that can be filtered at the report level. When I just display the range of dates it works. If I set the report filter on the second unrelated date table to may I can get a list of 31 dates. But if I change that same visual to a card with a distinct count I get 310 instead of 31?? Any ideas?
