I need to calculate a measure and for doing so need to apply multiple filters to obtain the desired value. Filter expression can have multiple conditions too. #Customers := DISTINCTCOUNT( Sales [CustomerKey] ) Sales Amount := SUMX ( Sales, Sales [Quantity] * Sales [Unit Price] ) Copy Conventions # 1. The inner CALCULATE is executed for each customer and returns the sales of that customer before 2012. Note that DAX is not case-sensitive, Red and red would be the same. The difference is the context of evaluation. I need to create a dynamic DAX measure which will give me the values if both conditions are filtered. Both the condition must be satisfied for a true result to be returned. I already tried some options suggested in this forum like the ones appointed by @amitchandak in this previous post Microsoft defines IF() as a function that "checks a condition, and returns one value when it's TRUE, otherwise it returns a second value." Hi,Calculate has a built in [filter] places in its expression and thus you don't need to add FILTER to your calculation. Then write the below-mentioned Dax Expression in the formula bar and click on the check icon: If so, would you like to mark his reply as a solution so that others can learn from it too? A = CALCULATE (COUNT ('Incident Report' [Form ID]), 'Date', 'Incident Report' [Event Type]="Lost Time Injury") CALCULATE(. Returns true or false depending on the combination of values that you test. 1. Most users usually are not big fans of writing of complex logical functions, neither in excel formulas nor in DAX. The following example calculates the number of Italian customers who bought something before 2012. Not the answer you're looking for? CALCULATE makes a copy of the CALCULATE evaluates all the explicit filter arguments in the original evaluation context, each one independently from the others. The order of evaluation of the parameters of a function is usually the same as the order of the parameter: the first parameter is evaluated, then the second, then the third, and so on. Table_1.col_A = value_1 OR Table_2.col_B = value_2. if any of conditions are not fulfilled, status is closed . Calculate has a built in [filter] places in its expression and thus you don't need to add FILTER to your calculation. The Switch is a very simple and efficient function in DAX (and many other languages) to help writing multiple IF statements much easier, Switch is written in this way: SWITCH (
