And, Or, NOT - DAX Guide

The logical and operator && returns TRUE if both arguments are TRUE, and returns FALSE if any of the arguments is FALSE.

The logical or operator || returns TRUE if any of the arguments are TRUE, and returns FALSE if all arguments are FALSE.

NOT inverts the state of a boolean expression, transforming FALSE to TRUE, or TRUE to FALSE.

This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.


#dax #powerbi #ssas #tabular #analysisservices #powerpivot

[clementejosemartinezserpas]

Bravo. I love these videos. To the point.

[maheshdama]

I created two matrix visuals with same amount of data. In one visual I applied visual level filter (top n)to get the top5 months by country while in other visual I filtered the top 5 months by ranking. interestingly I saw a very strange behaviour in the result. visual level filtering skip the 5th one and shows the 6 the one but when I apply filtering from the country slicer both shows the same values. could you clarify that where I did mistake. I used power bi financial sample data.