LECTURE 06/03/2024
Duplicate the page we have in Power BI and leave only the measures Sales to Bachelors
and Sales.
If we click on the measure applied in the data list, we can see its code
We are looking at the Sales to Bachelors measure. We know that with this code, we have
visible rows of Sales filtered by color and then also by the condition
EnglishEducation=Bachelors.
What if I want to see the sales to Bachelors in 2003?
→ in order to check more than one condition, we need to use a LOGICAL OPERATOR→ it is
an operator/function whose output is a logical value, which is either TRUE or FALSE.
We’re studying the principal two: AND & OR
The AND function/operator gives the output TRUE only if all the conditions we gave it as
input are true at the same time.
The OR function/operator always returns TRUE. The only condition in which it returns
FALSE, is when all the conditions we gave it are false at the same time.
In DAX, we can generate functions AND only with 2 conditions. If we need 3 or more
conditions, we need to nest the AND with another AND. The AND operator for 3 or more
conditions is advisable to use, since it doesn’t need to nest multiple AND functions.
Code to see sales to Bachelors in 2003
- start copying the code of Sales to Bachelors
= SUMX(FILTER
(Sales,
RELATED(Customer[EnglishEducation]) = "Bachelors"
)
,Sales[UnitPrice]*Sales[OrderQuantity]
)
- create a new measure in Sales → Sales to Bachelors 2003
= SUMX(FILTER
(Sales,
AND(
RELATED(Customer[EnglishEducation]) = "Bachelors",
RELATED(‘Calendar’[CalendarYear]= 2003
)
)
,Sales[UnitPrice]*Sales[OrderQuantity]
)
→ every row would be included, only if the AND function returns TRUE
The more conditions we put in, the less we'll see, since we’re always more restricted.
ATTENTION= this number must be written without “”
