Create a SUMIFS like Measure in Power BI
This video shows how to create a measure in Power BI that imitates or similar to a SUMIFS or AVERAGEIFS formula in Excel wherein you need to get the sum of a certain field only if it follows a certain condition or criteria.
Though this can be done using filters, a measure has the benefit of being a variable that you can use in later formulas and not something that exists only in visuals.