Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I cannot get the correct sum when trying to sum a group of values where I want to collect the ones that have been updated most recently by week.
I have created a filter saying Date = Max(Date), so that when I select a week, I want to sum the newest data for that period.
balance_USD = CALCULATE(
SUMX(factTable; 'factTable'[amount_USD]);
FILTER(factTable; factTable[dataSource] = "BANK");
FILTER(cal_Reported; cal_Reported[Date] = [maxDate_Reported]) )
I have two dates for the week I am running, and it sums both...
Anyone who can see what I am doing wrong?
Br Espen
Solved! Go to Solution.
Seems that I have fixed the issue, still not quite sure how...
I changed the MAX(Date) variable, adding a ALLSELECTED filter to it:
maxDate_Reported = CALCULATE(
MAX(factTable[date_reported]);
FILTER(ALLSELECTED(factTable);
factTable[dataSource] = "BANK"))
Seems that I have fixed the issue, still not quite sure how...
I changed the MAX(Date) variable, adding a ALLSELECTED filter to it:
maxDate_Reported = CALCULATE(
MAX(factTable[date_reported]);
FILTER(ALLSELECTED(factTable);
factTable[dataSource] = "BANK"))
Hi @jaco1951,
Glad to hear that you have resolved by yourself.
Regards,
Yuliana Gu
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |