how to calculate total of sales per year

[pboric]

I have a table with detailed sales over several years. I want to have a report showing the total sales for each year. I created a measure that calculates the total sales in the full table, but if I try to separate it for each year, I just get the total amount in all of the years. 

[pboric]

I did a further review and found myself with the same solution. There was a missing relation between the tables ¡

Thanks again 

[pboric]

Thanks, I was further reviewing and found myself the same solution, there was a missing relation between both tables

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I guess there might be no relationship between the fact table and the calendar table.

I tried to create a sample pbix file like below, and please chech the below picture and the attached pbix file.