To hide the matrix in case of selection

[Anonymous]

Please help, I have created the matrix with multiple values

I want it to be shown only in case the user selected the exact title from the slicer. I have already tried with this measure:

QuestionSelectCheck = IF(HASONEFILTER(Query3[Please indicate the title of the solution]),"1","2") but it doesn`t provide me a possibility to choose the value from filter as it should be 

Kindly help as there is no reason to see this matrix until the needed title is chosen 

[v-shex-msft]

Hi @Anonymous,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Anonymous]

https://1drv.ms/u/s!Asx0w5w5JIE_dHZ6vb6KbAgssmM?e=nRWcFq

I do not want to see a matrix if training is not selected

[v-shex-msft]

HI @Anonymous,

After checking your sample file, I find the value seems to form different fields. The current measure filter seems not suitable for this scenario.
I'd like to suggest you duplicate a table to use unpivot column feature to convert these fields to attribute and value. Then you can simply create a matrix and add a filter to value fields to exclude the not matched values.

Unpivot columns - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng