at 12:17 noted issue with the code for the dynamic table - the MAX values for Low match the min value for Med, also the same issue between Medium & High - if you applied this you would either get an error or more than 1 price range (depending on how you use that type of table) Love the rest of the video content
Can we able to apply this technique in multiple tables, like we are summarizing records from a single table and matching the tuples, but what if we need to pass the tuple to multi tables by using summarize columns, will this still works ?
Felice Anno Nuovo, First watch of you this year. How would you write this for CONTAINSROW, a function I find endlessly confusing, not sure why, so example ; EVALUATE FILTER ( ALL ( Table2 ), CONTAINSROW ( {"Red","Blue"}, [Color] ) )
EVALUATE FILTER ( ALL ( Table2 ), CONTAINSROW ( {"Red","A"} , [Color], [Item] ) ) I've tried various options for the above none of which work, any ideas, I've also found this re CALCULATETABLE; EVALUATE VAR ValuesV = CALCULATETABLE( ALL(Table2[Item] ), Table2[Color] IN { "Red", "Green"} ) VAR anser1 = CALCULATETABLE( All( Table2), [Item] IN ValuesV ) VAR anser2 = FILTER( ALL( Table2) , [Item] IN ValuesV ) RETURN anser1 The filter works ; answe2 , but not as Calc table, if this is in 'The Book', please let me know. Best wishes and success.
Excellent summary of what is possible with the different DAX-expressions, and when to use which.
What a insightful content. Thanks to SQLBI
Excellent presentation and examples! Gave me some MDX chills seeing tuples used like this.
Marvelous lesson. I don’t know how I could not know it before :) Thank you Marco and SQLBI Team!
It is super helpful that you showed how to use the technique with 2 dimension tables. Really awesome job!
at 12:17 noted issue with the code for the dynamic table - the MAX values for Low match the min value for Med, also the same issue between Medium & High - if you applied this you would either get an error or more than 1 price range (depending on how you use that type of table)
Love the rest of the video content
This is so cool, I can definitely use these techniques to simplify and optimise some existing and future queries
Great video. I will start using these techniques right away.
Lots of hidden gems
Thanks!!! Always learning something new.
This is absolutely awesome 🎉❤
Amazing..!!
How did you get that DAX evaluator thing to appear in the left hand side where tables/relationships are?
It’s the Dax query view - the forth icon added in the left view after viz, table and model
❤
Can we able to apply this technique in multiple tables, like we are summarizing records from a single table and matching the tuples, but what if we need to pass the tuple to multi tables by using summarize columns, will this still works ?
Look at the last example of the article/video, it seems matching your requirement.
Felice Anno Nuovo, First watch of you this year.
How would you write this for CONTAINSROW, a function I find endlessly confusing, not sure why, so example ;
EVALUATE
FILTER (
ALL ( Table2 ),
CONTAINSROW (
{"Red","Blue"}, [Color] ) )
EVALUATE
FILTER (
ALL ( Table2 ),
CONTAINSROW (
{"Red","A"} , [Color], [Item] ) )
I've tried various options for the above none of which work, any ideas,
I've also found this re CALCULATETABLE;
EVALUATE
VAR ValuesV =
CALCULATETABLE(
ALL(Table2[Item] ), Table2[Color] IN { "Red", "Green"} )
VAR anser1 =
CALCULATETABLE( All( Table2), [Item] IN ValuesV )
VAR anser2 =
FILTER( ALL( Table2) , [Item] IN ValuesV )
RETURN
anser1
The filter works ; answe2 , but not as Calc table, if this is in 'The Book', please let me know.
Best wishes and success.
The ALL in anser1 is removing the filter, if you use CALCULATETABLE ( Table2, ... ) then it should work.