Forum Discussion

JGARROD's avatar
JGARROD
Helper I
3 years ago
Solved

Filter a table by a parameter

Hi,    I have a table which is being profilied, as such another table has been created which does a number of thing such as count distinct, distributon of value etc for all columns of the underlyin...
Need Help
  • ToddChitt's avatar
    ToddChitt
    3 years ago

    I have never tried this so just guessing here:

    Add a derived column in Power Query and concatenate the Status column with the literal ", Both" so now that column contains values like "Active, Both" or "Inactive, Both". Filter on that column with a CONTAINS comparison against the Parameter value. 

    This may fail depending on if the comparison engine thinks that "Active" is CONTAINED in "Inactive, Both" even though it is a capital A versus a small a. But I *think* Power Query is CASE Sensitive.

    Try it and let us know how it goes.

JGARROD's avatar
JGARROD
Helper I
3 years ago

Yep this was it, it came to me when i tried to use numbers rather than words and also the 'CONTAINED' so ive ended up with a column with two values 'All Active, All Inactive' and then a Parameter with 3 values : All, All Inactive, All Active. 

 

By using the contains on the filter i can filter by All, or by individual.