The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
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.
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.
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.
-----------------------
@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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
153 | |
120 | |
119 | |
73 | |
61 |
User | Count |
---|---|
248 | |
119 | |
107 | |
98 | |
93 |