Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

help with filter for multiple flags

Hi there,

 

trying to build a filter that covers multiple overlaping flags. I've followed multiple guides but can't get it full working.

 

I've concatanated the flags into one value, that looks a lot like this....

 

I also have another table that has the 4 values as a list (1 column with 4 rows A,B,C,D)



I struggle with the final steps;

What sort of relationship should I have with the 2 tables? 
Whats the DAX that I use to say bring through only the selected values?

 

Thanks in advance!

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for the reply.

    There's too many calculations to mention, there's lots going on.

    Unpivot wont fix this (IMO) - the challenge here is not the shape of the data, it's the fact that a row can have a number of flags so need a way of picking these up.

    -----------------------


  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi Anonymous ,

    Based on your description, not certain what is your expected output, the combined column or anything else?

    In your sample table, what did the Flag column mean?

     

    Could you please consider sharing more details about this issue for further discussion?

     

    Sample data and expected output would help tremendously.
    Please see this post regarding How to Get Your Question Answered Quickly:
    https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Sorry,

      Things always seem clear when you're writing them.

      The outcome I need is something (I suspect a measure) that will give me the 4 options A,B,C,D that then filter based on the flags in the table.