Forum Discussion
Fields parameter filters another field paramater
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.
Hi Anonymous ,
Please new a measure:
Measure = VAR __parameter1 = SELECTEDVALUE('Parameter1'[Parameter Fields]) VAR __filter = IF(MAX('Parameter2'[Parameter Fields])<>__parameter1,1) RETURN __filterand apply it to the second slicer's filter:
result:
Best Regards,
Gao
Community Support TeamIf 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
2 Replies
Hi Anonymous ,
Please new a measure:
Measure = VAR __parameter1 = SELECTEDVALUE('Parameter1'[Parameter Fields]) VAR __filter = IF(MAX('Parameter2'[Parameter Fields])<>__parameter1,1) RETURN __filterand apply it to the second slicer's filter:
result:
Best Regards,
Gao
Community Support TeamIf 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