Power BI: DAX Calculate function
The CALCULATE function evaluates a given expression or formula under defined filters.
CALCULATE ([expression], [filter1[, [filter2]…)
The expression can be either a formula, such as SUM, COUNT, etc, or an existing measure.
Filters are simple logical data types also known as Boolean values (TRUE or FALSE). For example, a filter can refer to the column city = “London” or the column year = 2020.
Excel users can relate the DAX CALCULATE function to Excel’s SUMIF or COUNTIF. Their logic is very similar.
To learn more about Power BI visit: https://centida.com/index.php/blog/
#DAX #PowerBI
#Calculate