Using tuple syntax in DAX expressions

Use of the tuple syntax in DAX expressions to simplify comparisons involving two or more columns, like month and year.
Article and download: sql.bi/826262?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

[@sanjeevgupta7177]

What a insightful content. Thanks to SQLBI

[@holahandstrom]

Excellent summary of what is possible with the different DAX-expressions, and when to use which.

[@mnowako]

Marvelous lesson. I don’t know how I could not know it before :) Thank you Marco and SQLBI Team!

[@SQLMonger]

Excellent presentation and examples! Gave me some MDX chills seeing tuples used like this.

[@yippiekyoo]

It is super helpful that you showed how to use the technique with 2 dimension tables. Really awesome job!

[@kopite833]

This is so cool, I can definitely use these techniques to simplify and optimise some existing and future queries

[@Mark-zs9sm]

Great video. I will start using these techniques right away.

[@ar6715]

Amazing..!!

[@mathew9665]

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

[@KedielSanchezMariano]

Thanks!!! Always learning something new.

[@navisalomi]

This is absolutely awesome 🎉❤

[@timothytim1053]

How did you get that DAX evaluator thing to appear in the left hand side where tables/relationships are?

[@anilkapkoti296]

❤

[@vijayvizzu1]

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 ?

[@SQLBI]

Look at the last example of the article/video, it seems matching your requirement.

[@williamarthur4801]

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.

[@SQLBI]

The ALL in anser1 is removing the filter, if you use CALCULATETABLE ( Table2, ... ) then it should work.