I am having a pretty weird problem that I cannot seem to solve. It is weird because it seems to be a very basic problem.
Here is what I want to achieve: I want to write a measure that calculates the total revenue for a specific date (the specific date being the last day when a customer placed an order). Nothing easier than that, right?
Revenue:Last Day=CALCULATE([Revenue],Filter('Calendar','Calendar'[Date]=[Last Order Date]))
However, this does not work. This measure returns the total revenue for the entire period. That is, the output of this measure equals the [Revenue] measure.
I am pretty convinced that this must be a formatting-related problem. Simplifying the above code makes this pretty obvious in my opinion:
This formula returns blank values.
The only way I can actually make this work is with the Date() function and using a static condition:
This formula returns the correct numbers. But since this measure is static and not dynamic, it is not what I want.
I also tried to adjust the formats:
Again, this is not working.
So I am left wondering how I can use calculate in combination with a specific date?