AND DAX Function

Checks whether both arguments are TRUE, and returns TRUE if both arguments are TRUE. Otherwise returns false. It comes under Logical DAX functions category.

Syntax:

AND(logical1, logical2)

Parameters

logical1, logical2 – The logical values you want to test.

Download the sample Dataset from below link-

• Global Super Store Dataset

Let’s understand with an example:

See the below sample data, here we have Category, sub category and Sales data.

Suppose you are interested to see the sales only where Category = “Furniture” and Sub Category =”Chairs”.

In order to achieve this you can use AND DAX function, it will check both conditions are true or not, if both conditions are TRUE then returns TRUE otherwise returns false.

Now create one measure for AND Dax function-

SUM with AND =
CALCULATE(
SUM(‘Global-Superstore'[Sales]),
FILTER (‘Global-Superstore’,
AND (
‘Global-Superstore'[Category] = “Furniture”,
‘Global-Superstore'[Sub-Category]=“Chairs”
)
)
)

Now drag the measure to Table and in Card visual, it will return the sum only for whether both conditions are true.

Another way to write AND function-

Instead of AND you can use && sign, let’s have a look in below DAX code.

SUM with AND = CALCULATE(
SUM('Global-Superstore'[Sales]),
FILTER (
'Global-Superstore',
'Global-Superstore'[Category] = "Furniture" &&
'Global-Superstore'[Sub-Category]="Chairs"
) )

Refer more DAX functions: DAX functions

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our Contact form , we will revert to you asap.