Forum Discussion
Measure to filter rows from two different tables
I have two tables, both with a "swap" column that is either "Y" or "N". I want a measure to put in a slicer to filter the page to show all rows in both tables that have "Y". I can't make the relationship between the two swap columns active because there's already an active relationship between the two tables on the date columns. Is this possible?
This hasn't been solved, but I found my own workaround
6 Replies
Create a reference dimension table with the same "swap" column and the two values. Join that table into the data model so it controls both fact tables. Then use the dimension column for the slicer.
Hi stoppm
create a separate table with Y & N
create two measures to filter each tables
use these measures in tables filter panel & say you need to see only 1
ShowTable1Rows = VAR SelectedValue = SELECTEDVALUE('Swap Filter'[Swap]) RETURN IF( MAX('Table1'[swap]) = SelectedValue, 1, 0 )and use new table column as filter and both your tables will get filter accordingly without using relationships
Hi stoppm
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
This hasn't been solved, but I found my own workaround
Hi stoppm
That's great to hear you found a workaround. Please share those helpful insights in the community and accept that reply as the solution. This will be helpful for other community members who have similar problems to solve faster.
Thank you.
Hi stoppm
As you mentioned earlier that you found a workaround, we request you to post that workaround in this community and accept that reply as a solution.
Thank you.
