Thanks Marco for posting this video! I was the one posting the question and it feels great that the answer wasn’t obvious for you either even though everyone think you guys are super (DAX) human :-) awesome to see you work towards the answer and finally nailing it
Thanks for sharing. How about finding the sales of "And Product" within the transactions? You had already catered for the overall transaction sales, sales for both the products and "Product" Sales. Any chance for the unplugged video on that?
Thank you for the video. I would like tio know if its possible to get sales of orders that contain one products and not the other product like 'And Not Product' ?
What happens if you put DISTINCT( UNION (A, B) ) for this pattern? Will this work too? I guess my question is don't we have to worry about duplicated values inside the variable?
the ProductsCombine variable will create a single column table that will be part of the filter context How ?? :D , are they gonna filter the products ? but they are different tables right ? or will the VALUES(Prooduct[ProductKey]) will filter product,, and the VALUES('And Product'[And Product Key]) will filter the "And Product" table ? ..... im just confused because the union willl return a single column table and how does the engine know that it has to filter the right table... ? is it because of data lineage ? :D
Thank you so much for the unplugged series. We learn so much watching you apply different techniques.
Thanks Marco for posting this video! I was the one posting the question and it feels great that the answer wasn’t obvious for you either even though everyone think you guys are super (DAX) human :-) awesome to see you work towards the answer and finally nailing it
Good recovery on TREATAS near the end. It's always the lineage :)
Awesome. Just a few changes and quite different insight. Great example for learning. Thank you. 👏
Thanks for sharing. How about finding the sales of "And Product" within the transactions? You had already catered for the overall transaction sales, sales for both the products and "Product" Sales. Any chance for the unplugged video on that?
Ciao !!
From Thailand
Thank you for the video. I would like tio know if its possible to get sales of orders that contain one products and not the other product like 'And Not Product' ?
You should create an additional slicer and modify the filter to apply the condition. Good topic for another unplugged!
@@SQLBI Looking forward for this unplugged video ...
What happens if you put DISTINCT( UNION (A, B) ) for this pattern? Will this work too? I guess my question is don't we have to worry about duplicated values inside the variable?
Not sure it's related - but the result of that expression loses the data lineage if you want to use it as a filter.
What do you means by Sales Combined Products is it Sales of (And Product)?
Sales of orders that contain both products selected.
the ProductsCombine variable will create a single column table that will be part of the filter context How ?? :D , are they gonna filter the products ? but they are different tables right ? or will the VALUES(Prooduct[ProductKey]) will filter product,, and the VALUES('And Product'[And Product Key]) will filter the "And Product" table ? ..... im just confused because the union willl return a single column table and how does the engine know that it has to filter the right table... ? is it because of data lineage ? :D
ahhhhhh i think i got my awnser t the end of the video :D :D :) :)
*me watching seriously without understanding anything 😅😅😅😅