Using the DAX CALCULATE Function

This video will cover using the DAX function called CALCULATE. Think of this function as a powerful SUMIF or COUNTIF function or maybe a "CALCULATE-IF" function. It will bring back some measure based on some criteria. In Power Pivot, it's useful in creating filtered conditions that bring some additional benefits to analyzing data. This video covers creating a simple relationship between two table and how the CALCULATE function can be used