Excel Magic Trick 1323

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

DESCRIPTION

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.

WORKBOOKS

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




Be the first to comment

Leave a Reply