DAX Filter Functions: FILTER and CROSSFILTER
Using the FILTER function combined with ALL to calculate cumulative sums, and the CROSSFILTER function to modify cross-filter direction on relationships for ad-hoc analysis without changing the semantic model.
