Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I want to get the values of yesterday's sales from country USA. To do that, I tried the measure below:
For yesterday =
CALCULATE(
[Sales USD],
FILTER (
ALL ( 'TY Group'[Country],'TY Group' [Calendar Day] ),
'TY Group'[Country]="USA" || 'TY Group'[Calendar Day] = TODAY()-1))
But only the first (Country) filter worked and had the sum of sales for the all period.
Could anyone help me with this?
Thanks in advance.
Solved! Go to Solution.
@Julia_Mav Maybe:
For yesterday =
CALCULATE(
[Sales USD],
FILTER (
ALL ( 'TY Group'[Country],'TY Group' [Calendar Day] ),
'TY Group'[Country]="USA" && 'TY Group'[Calendar Day] = TODAY()-1))
However, if you are using a single table data model, you may be running into issues with CALCULATE. What is the formula for your [Sales USD] measure?
Hi Julia_Mav
I guess, I would try to use && instead of ||. At the moment your DAX formula is just considering one of the two criterias.
Hi Julia_Mav
I guess, I would try to use && instead of ||. At the moment your DAX formula is just considering one of the two criterias.
@Julia_Mav Maybe:
For yesterday =
CALCULATE(
[Sales USD],
FILTER (
ALL ( 'TY Group'[Country],'TY Group' [Calendar Day] ),
'TY Group'[Country]="USA" && 'TY Group'[Calendar Day] = TODAY()-1))
However, if you are using a single table data model, you may be running into issues with CALCULATE. What is the formula for your [Sales USD] measure?
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |