The Great Precedence Project (Filter Rules for DAX)
Some example questions to ponder:
1.Within a FILTER or a CALCULATE, does the order of the filter arguments ever make a difference?
2.Does using an ALL inside of a FILTER yield different results than using an ALL inside of a CALCULATE?
3.Measures that are used inside of a FILTER or DATESBETWEEN are never impacted by external filter-setting forces are they? Or are they?
Read more Part 1...