Forum Discussion
Anonymous
3 years agoNot applicable
different filters on same 2 visuals on same page?
I wanted to display the same 2 visuals; but one shall have more restricted content… My dataset consists of: Fact Project 345 1 3451 2 591 3 100000 4 ...
MohammadLoran25
Solution Sage
3 years agoHi Anonymous,
Please follow these steps:
1-Duplicate your "Dimension" table and name it "SecondDimension" as your new table.
2-Then Create a flag measure as below:
SELECTEDTEAMFLAG =
VAR _SELECTEDTEAM =
SELECTEDVALUE ( Dimension[Team] )
RETURN
SUMX (
FILTER ( SecondDimension, SecondDimension[Team] = _SELECTEDTEAM ),
1
)
3-Then add your second visual fields from the "SecondDimension" table.
4-Put the measure [SELECTEDTEAMFLAG] as a filter on the visual you just made in step 3 and set the condition of is 1 for it. You also need to set the condition for role as "Boss" on it which is shown in the attached image.
If it solves your problem, then please consider Accepting it as the solution
Regards,
Loran