Year to Date

[jak82]

Hi,I am trying to do a 'year to date' but my card is only showing 396.00 which is very wrong, my DAX is .The problem is it should be a lot more, does the DAX look ok?

[/LEFT]
yTD = TotalYTD(sum(adDetails[Revenue]), calender[Date], All(calender))

 

[akice]

The formulas as written looks ok, although the filter argument 'All(calendar)' is not needed because internally Dax re-writes the formula with an 'All' already (Assuming 'Calendar' is related to 'adDetails' via 'Date' field).

I would double check relationships and make sure the max date value you were expecting truly is the max value in the current filter context.

 

[jak82]

Thanks Akice was a filter issue