AND Function (DAX)
Checks whether both arguments are TRUE, and returns TRUE if both arguments are TRUE. Otherwise returns false.
The logical values you want to test.
Returns true or false depending on the combination of values that you test.
The AND function in DAX accepts only two (2) arguments. If you need to perform an AND operation on multiple expressions, you can create a series of calculations or, better, use the AND operator (&&) to join all of them in a simpler expression.
The following formula shows the syntax of the AND function.
=IF(AND(10 > 9, -10 < -1), "All true", "One or more false"
The following sample uses the AND function with nested formulas to compare two sets of calculations at the same time. For each product category, the formula determines if the current year sales and previous year sales of the Internet channel are larger than the Reseller channel for the same periods. If both conditions are true, for each category the formula returns the value, "Internet hit".
Bottles and Cages
Tires and Tubes
= IF( AND( SUM( 'InternetSales_USD'[SalesAmount_USD]) >SUM('ResellerSales_USD'[SalesAmount_USD]) , CALCULATE(SUM('InternetSales_USD'[SalesAmount_USD]), PREVIOUSYEAR('DateTime'[DateKey] )) >CALCULATE(SUM('ResellerSales_USD'[SalesAmount_USD]), PREVIOUSYEAR('DateTime'[DateKey] )) ) , "Internet Hit" , "" )