Скачать или смотреть Dax8 - Calculate with FILTER - KEEPFILTERS

Calculate is the most powerful function in Data Analysis Expressions (DAX), which has the ability to add, modify and remove any filters from the current filter context applicable on any calculation. You cannot master DAX without mastering the Calculate function.

FILTER returns a table that represents a subset of another table or expression. Based on the condition specified, DAX will create a subset of a table matching the given condition(s).

KEEPFILTERS modifies how filters are applied while evaluating a CALCULATE function. It basically adds a filter condition in the current filter context.

You can get the .pbix file from here.
https://tinyurl.com/yyk8xk7x

Enjoy Dax!