Forum Discussion
Solved
Filter context weirdness
Hi there! Perhaps a newbie question, but I can't wrap my head around how a measure reacts to filters... I have a measure that calculates sum of sales for the most recent day in the data : ...
paulpassot
Aparently this is Auto-Exist problem.First step try to manually calculate the last day sales. If it does not match the result of my first solution then you need to have a date table that filters your data set. This will totally eleiminate the problem.
paulpassot , Try like
Max Day Sales =
CALCULATE(
SUM( Invoices_LQ[InvoiceLine.Amount] ),
lastdate(Invoices_LQ[PostDate_DateFormat] )
)
for date
MAxx(ALL( Invoices_LQ[PostDate_DateFormat] ), Invoices_LQ[PostDate_DateFormat] )
Unfortunately it doesn't work, it gives me the values for each date: