Table linking issue?

[Anonymous]

Today's Sales = CALCULATE(sum(SALES[Sales]),LASTDATE(SALES[Ship Date]))

This gives me $30,384 in the "Card" tile.

I create a "Matrix" tile and put Today's Sales in the Values section and "Category" from the "Part Number Master" table in the Rows section.  The total is correct, $30,384 but the information above the total does not actually total $30,384.  Anyone have any ideas?

[Habib · Accepted solution]

Hi @Anonymous,

Actual issue is the usage of LASTDATE function. It picks last date of a column in current context. Let's assume, one category which doesn't has sales for today, during the calculation for that category, it will pick yesterday's sales but in total or card, current context is for all entire table regardless of category so it will pick today's date.

You should use TODAY function.

[Anonymous]

That makes since.  Thank you!