Forum Discussion
Dynamically filter one table by another without using relationships
Hi jamesbw ,
You can use the query editor to create a merged table as a slicer, and create if measure as a visual level filter.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thank you to everyone for your potential solutions, it is much appreciated.
I managed to resolve my problem by connecting the DDL Filter table to the A x B table with a relationship and then set up this measure which I then filtered in a visual table with E Name to only show values which were greater than zero:
CustomFilter = VAR MyFilter = VALUES('DDL Filter'[Filter])
RETURN
SUMX('B X C', IF('B X C'[DDL] IN MyFilter, 1, 0))
Hi jamesbw ,
You can use the query editor to create a merged table as a slicer, and create if measure as a visual level filter.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you to everyone for your potential solutions, it is much appreciated.
I managed to resolve my problem by connecting the DDL Filter table to the A x B table with a relationship and then set up this measure which I then filtered in a visual table with E Name to only show values which were greater than zero:
CustomFilter = VAR MyFilter = VALUES('DDL Filter'[Filter])
RETURN
SUMX('B X C', IF('B X C'[DDL] IN MyFilter, 1, 0))