different filters on same 2 visuals on same page?

[ovonel]

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

Dimension

Project	Role	User Number	Team
1	Boss	55	C
1	Lead	11	C
1	Work	43	C
2	Boss	99	C
2	Lead	1034	D
2	Work	9	C
3	Boss	5	C
3	Lead	419	C
3	Work	4	A
4	Boss	2	A
4	Lead	5184	P
4	Work	14519	A

I will add 2 filters in my page: User Number and Role.

If a user for example selects     User: 5, role: Boss.

One visual should display only that; and the other visual should display, all Bosses from Team C (this is user’s 5 team). That is:

Project	Role	User Number	Team
1	Boss	55	C
1	Lead	11	C
1	Work	43	C
2	Boss	99	C
2	Lead	1034	D
2	Work	9	C
3	Boss	5	C
3	Lead	419	C
3	Work	4	A
4	Boss	2	A
4	Lead	5184	P
4	Work	14519	A

I want to achieve this by giving the user just 2 filters: User Number and Role.

[MohammadLoran25]

Hi @ovonel,

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