how to keep some filter context and remove others

MarinaGP · ‎04-03-2023

HI All;

I have a question I can't figure out

My table is

My visualization is driven by slicer on Terr

I need two table visuals:

One driven by slicer by Territory

	Territory Status
	2017	2018	2019	2020	2021	2022
Rep1	Status1	Status2	Status3
Rep2	Status1	Status2	Status2			Status2

and another that gives me all the Reps in the selected Territory but with all the global status for all the years of the global status.

Desired output

	Global Status
	2017	2018	2019	2020	2021	2022
Rep1	Status1	Status2	Status2	Status2		Status3
Rep2	Status1	Status2	Status2	Status2	Status2	Status2

At the moment I can only get the global status only from the Territority years.

How can I create a measure that keeps the Reps from the territory but gives me all the status for all the global status years?

Greatly appreciate your help.

Ashish_Mathur · ‎04-04-2023

Hi,

Confusing question. What do you mean by "gives me all the status for all the global status years"? Explain the expected result in detail.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

lbendlin · ‎04-04-2023

My visualization is driven by slicer on Terr

does it have to be? Can you train your users on how to use the filter pane?

Helpful resources