I have following formula to calculate total sales
TotSales'16:=if([StewTot]>=10,sum(SALESDATA[AMOUNT]),blank())
[StewTot] as the formula = Sum('STEWARD ATTENDANCE'[DAYS WORKED])
it works in PT with month on row filter, but total is getting wrong.
so, to show the correct total i tried this
SubTotal:=sumx(VALUES('STEWARD ATTENDANCE'[DAYS WORKED]),
CALCULATE (
sum(SALESDATA[AMOUNT]),
'STEWARD ATTENDANCE'[DAYS WORKED] >= 10))
returns wrong value...
TotSales'16:=if([StewTot]>=10,sum(SALESDATA[AMOUNT]),blank())
[StewTot] as the formula = Sum('STEWARD ATTENDANCE'[DAYS WORKED])
it works in PT with month on row filter, but total is getting wrong.
so, to show the correct total i tried this
SubTotal:=sumx(VALUES('STEWARD ATTENDANCE'[DAYS WORKED]),
CALCULATE (
sum(SALESDATA[AMOUNT]),
'STEWARD ATTENDANCE'[DAYS WORKED] >= 10))
returns wrong value...