Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 i...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
Anonymous
Not applicable
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

Perfect, thankyou.