Filter twice and get full list in matrix visual. Isinscope isfiltered?

[Chris_23]

Hi,

i've got troubles to achieve the desired state:

(1) I have a list of four alerts. If i filter one of those, (2) i get the result of the selected one. Now i want to achieve, if i select one (crtl+select) of those compatitors out of the list, i want to see (3) the whole results of the alerts where the selected compatitor was involved. Unfortunaltley i only get the results and Job of the slected one and not the result of the whole alert:  

Any ideas to solve this problem? I have tried some Measure of ISINSCOPE and ISFILTERED. But unfortunately they didn't work.

Example pbix:

https://1drv.ms/u/s!AsLM3f2rQCP34xr-L9q0LCky9UYx?e=26gTQL

Kind regards

Chris

[v-luwang-msft · Accepted solution]

Hi @Chris_23 ，

Pls refer the below and check if it is helpful:

https://community.powerbi.com/t5/Community-Blog/Filter-Twice-to-Get-the-Table-We-Need/ba-p/1702504 

Best Regards

Lucien