Fields parameter filters another field paramater

[Anonymous]

Hi, 

I have two fields parameters for the same measures, that enables users to compare metrics in a Line & Column chart.

Is it possible that whatever value is selected in one field parameter is removed from the other. As below.

Thanks.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please new a measure:

Measure = 
VAR __parameter1 = SELECTEDVALUE('Parameter1'[Parameter Fields])
VAR __filter = IF(MAX('Parameter2'[Parameter Fields])<>__parameter1,1)
RETURN
__filter

and apply it to the second slicer's filter:

result:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous]

Perfect, thankyou.