Forum Discussion
Power Bi Challenge - Round1
My submission is attached.
(Edited to hack the sort order to match specifications.)
AlexisOlson
That is absolutely brilliant!! Knowing how amazing you are in Power Query, I was expecting you to build the Brands table using Power Query but you did it with DAX and you've smoothly transferred the filter using TREATAS. I feel extremely happy that I'm able to exchange knowledge with someone who is a next level comprehensive school! Thank you so very much for sharing your knowledge.
Here attached my solution which is very similar to yours except that I'm relying on a physical relationship to transfer the filter pushing most of the DAX to the table query. Also I have added aditional filters to exclude the brands that are selected in the other slicers.
tamerj1 When working with a PBIX that is shared online, I don't often use Power Query since the data sources aren't usually included so tinkering with the queries isn't much of an option. Also, cross-joins are easier in DAX than M, though I plan to write some custom functions to remedy that and submit them here at some point:
https://github.com/OscarValerock/PowerQueryFunctions
I'm a bit disappointed we had such similar solutions, but maybe that's just what the obvious one is. Part of the fun of such things is seeing wildly different ways of achieving similar things. If anyone else can think of a different approach, I'd love to see it.