help with filter for multiple flags

[Anonymous]

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!

[v-yingjl]

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]

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.

[Anonymous]

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.

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

[Fowmy]

@Anonymous 
Can you explain what sort of calculation are you trying to do?

Your data needs transformation, probably UnPivoting. Please refer to : https://www.youtube.com/results?search_query=excelfort