Forum Discussion
Lookup from multiple values in same column
Interesting request, I'll have a think. Can I ask why you want it displayed in this way? It may help the community figure out how to solve it if we understand the business requirement or reasoning, and what the restrictions are.
If I am understanding the requirement correctly, this will work, I'm just not sure if there's a more efficient way to do it:
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
Thats it AllisonKennedy !
The purpose was for me to be able to see how many students were enrolled on this particular combination of units, as they are options, and we use a clustered approach to teaching. Using this report we will be able to see which combination is more popular than others and diversify.
A slightly more esoteric question, but could you please explain how you understood what the steps to solve this were? I'm trying to work on building my own problem solving in PBI.
EpicTriffid Glad it worked!
To answer your question of how I got there, I just finished teaching day 1 of 'Mastering DAX' course today, so I'd say my steps to the problem solving are that I know a lot about DAX and Power BI. It's a bit tricky to explain in one simple post, but the key is to have a solid understanding of the Row and Filter context within DAX, how that fits in with the relationships in your data model, and what you are trying to achieve. Keep practicing and reading blogs and posts on this forum and you'll slowly get there, or find a course that meets your skill level.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.