Provide data to a visual based on a click on another visual, but give it a broader context (filter o

[yaronklein]

Dear community,
I have a problem that it seems to be quite easy to solve, but I cannot find a good solution for it.

Let’s assume that I have the following table to hold test results of two tests AAA and BBB that runs every day (Test Run and Date):

Test Run	Test Name	Date	Result
1	AAA	1/1/2022	Pass
1	BBB	1/1/2002	Fail
2	AAA	2/1/2022	Pass
2	BBB	2/1/2002	Pass
3	AAA	3/1/2022	Fail
3	BBB	3/1/2002	Fail

(Obviously the test list host thousands of tests and it runs for many days)

I have a table visual that shows the results of the last run:

Test Name	Result
AAA	Pass
BBB	Fail

When the user will press a test, I would like to show a table that will show all the results of the same test per day.

So, in my example if the user pressed the BBB line I will get the following table:

Test Name	Date	Result
BBB	1/1/2002	Fail
BBB	2/1/2002	Pass
BBB	3/1/2002	Fail

My problem is that when the user presses BBB I get only the result of the same day and there is no way that I am aware of that allow me to ignore filters in the visual.
Thanks in advanced for the help.

[yaronklein]

Hi @hnguy71 ,
Sorry that it took me some time.
I am ot sure what exactly you mean. it seems that you crated the solution in a smaple pbix. Will you be able to share it?
Thanks.

[yaronklein]

Hi @hnguy71,
By any chance, will you be able to provide a sample.
Thanks.

[hnguy71]

Hi @yaronklein, 

Sorry I haven't been active on the forums due to holiday break.

If you still need a sample, I've attached it here.

[v-binbinyu-msft]

Hi @yaronklein ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu

[hnguy71 · Accepted solution]

hey @yaronklein ,

Take your base measure that you used to get your first visual, and build a measure on top if it and you can use the ALLSELECTED function.

 

 EDIT: You may need to add your column in the ALLSELECTED, such as:

AllSelected = CALCULATE([BaseResult], ALLSELECTED(YOUR_TABLE[Result]))