Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |