Forum Discussion
Advocate IApply Report Page Filter to two Source Tables
The links above didn't help me figure out how to filter Stores2 from a Store Filter. I eventually used the below Measure to meet my needs:
FilterSelection = IF(LASTNONBLANK('Stores2'[npcsto_pk],"") in VALUES('Stores'[npcsto_pk]),1,2)
Then on any visual I wanted the Stores filter to apply to the Stores2 table or the tables it was related to, I would add the measure as a filter and set the filter to 1. It works, but it does require me to enter the FilterSelection measure into every visual's filters since I cannot apply it to Page level or All pages. I am accepting this as the solution, however if others know of a better way to do this, let me know.
Hi dwelsh ,
I mean you can break the relationship between transaction tables and create a calculate table with keys extract from stores. Then link stores with bridge table instead of direct links between transaction tables.
Notice: keep one major relationship instead of link all tables with different relationship keys, they may cause the issue when analysis records based on relationships.
What is the Direction of Relationship in Power BI?
Create and manage relationships in Power BI Desktop
Relationships in tabular models
Regards.
Xiaoxin Sheng
Advocate IThe links above didn't help me figure out how to filter Stores2 from a Store Filter. I eventually used the below Measure to meet my needs:
FilterSelection = IF(LASTNONBLANK('Stores2'[npcsto_pk],"") in VALUES('Stores'[npcsto_pk]),1,2)
Then on any visual I wanted the Stores filter to apply to the Stores2 table or the tables it was related to, I would add the measure as a filter and set the filter to 1. It works, but it does require me to enter the FilterSelection measure into every visual's filters since I cannot apply it to Page level or All pages. I am accepting this as the solution, however if others know of a better way to do this, let me know.