topic Re: how to calculate total of sales per year in DAX Commands and Tips

how to calculate total of sales per year

pboric — Tue, 01 Apr 2025 20:20:28 GMT

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.

Re: how to calculate total of sales per year

Jihwan_Kim — Wed, 02 Apr 2025 03:10:29 GMT

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.

Re: how to calculate total of sales per year

pboric — Wed, 02 Apr 2025 13:09:29 GMT

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

Re: how to calculate total of sales per year

pboric — Wed, 02 Apr 2025 13:14:23 GMT

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

Thanks again