Excel Magic Trick 1323: DAX Formula to Pass Many-Side Filter to One Side Aggregate Calculation

Download Excel Files:

See how to use the CALCULATE function and a Table from the Many Side of a One-To-Many Relationship to allow criteria (filter) to flow from the Many Side to an aggregate calculation on the One Side.
Thanks to PATRICK NYAMU at YouTube for this formula!
CALCULATE DAX Function & Many-Side Table as Filter

[paulstokes]

Thank you so much for sharing - your a life saver ! and learning this might have secured me a job :-)

[DougHExcel]

PowerPivot CALCULATE is an awesome swiss-army knife DAX function. Great example!

[patricknyamu]

No THANK YOU for being a great excel teacher the true hero

[isaacwarren]

Without this explanation, CALCULATE just won't cut it on its own. Thank you.

[correa.cristobal]

Hey there! I have a small issue that perhaps you could help me resolve. If there's any way to contact you outside of YouTube, please let me know! (I'm 100% sure it won't take more than possibly 10 minutes of your time). All the best man. And thank you very much, your vids have made the workbook possible thourgh and through!

[deepakagrawal]

DAX is tricky but very powerful, Mike. I'm also having a lot of fun with it. Thanks for this one. Kudos to Patrick!

[douglaszulu]

great video and insight from Patrick. thanks