sameperiodlastyear dax value is not displayed in the visual in power bi desktop?

[IloveTigray]

I am new to DAX. I have simple table for just trying DAx time intelligence functions.

dataset:

I created to measures as below:

totalsales TY = CALCULATE((SUM(Sheet2[amount]))) // works fine

SAMEPERIODLASTYEAR = CALCULATE([totalsales TY], SAMEPERIODLASTYEAR(Sheet2[recorddate])) // display total sum correctly.

then I add a table visual and added the columns:

Result:

Unfortunately the column in sameperiodlastyear is empty but the sum on its footer is correct.

kindly assist how to show the values of the same period last year for each row.

[IloveTigray]

as per your suggestion, I removed product, then it worked. thank you

[Anonymous · Accepted solution]

I believe this is because the individual product categories do not have an amount value for last year, the total is summing all of the sales figures except the one from the most recent date in your table as there is no product filter context on the total row in the table. If you were to remove the product column from your table visual, it should work as you'd expect. Also, if you added in more rows for each product with different date values that would also get it to show at row level.