Excel Magic Trick 1323

DAX Formula to Pass Many-Side Filter to One Side Aggregate Calculation


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.


Download “Excel Magic Trick 1321-1340” Excel-Magic-Trick-1321-1340.zip – Downloaded 845 times – 98 MB

Be the first to comment

Leave a Reply