Forum Discussion

Thom_'s avatar
Thom_
Frequent Visitor
4 years ago
Solved

Field Parameters - Individual Filters

Hi all!!   I have been using the field parameters feature (successfully I think) and now have a different issue that I'm wondering if it can be done. I will explain a simplified version of what I h...
Need Help
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Thom_ ;

    Sorry for the late recovery.

    You could change it.

    filter2 = SWITCH(MAX(Parameter2[Parameter2]),"Fl1", IF( [Fl1]="Y",1),"Fl2", IF( [Fl2]="Y",1),"Fl3", IF([Fl3]="Y",1))

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Thom_ ;

Try to create a filter measure.

filter = SWITCH(MAX('Parameter'[Parameter]),
"Flag1", IF( MAX('Table'[Flag1])="Y",1),
"Flag2", IF( MAX('Table'[Flag2])="Y",1),
"Flag3", IF( MAX('Table'[Flag3])="Y",1))

Then apply it into filter.

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Thom_'s avatar
    Thom_
    Frequent Visitor
    4 years ago

    Hi v-yalanwu-msft ,

     

    Thank you so much for this! 😁

     

    However, when I recreate this on my end I get an error saying Column 'xx' in table 'xxx' cannot be found or may not be used in this expression. I believe this is due to my Flag1, Flag2 and Flag3 columns being measures and not raw data for which it works in your example. I have recreated this and added it in the pbix you so kindly made. Is there a different but logically similar way to account for the fact my columns are measures?

    Link for the pbix file:

    https://www.dropbox.com/s/i7oedab5tsk0qnr/Field%20Parameters.pbix?dl=0