We all the time use filters when developing DAX expressions, reminiscent of DAX measures, or when writing DAX queries.
But what happens exactly after we apply filters?
This piece is strictly about this query.
I'll start with...
Imagine that we have now three measures:
Sales Amount
Sales Amount Budget
Sales Amount PY
Once we take a look at a table with these numbers, we see this (assuming that we have now current data until the...