MEASURE USING DATE AS A FILTER

[Anonymous]

I have this measure that i use to calculate the sum of all pieces from yesteday 

and the problem is that when i use the filter of date it doesnt work and just return blank, 

but when i dont use the filter it works 

but the problem is that i need it to work with the filter to compare with other dates.

Pleade i need help because i dont understand why it doesnt work 😞

[amitchandak]

@Anonymous , not very clear, but you can get this day and last day using time intelligence. example

This Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE(sum('order'[Qty]), previousday('Date'[Date]))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.