topic Re: Total Sales of Monthly data in DAX Commands and Tips

Total Sales of Monthly data

Anonymous — Tue, 16 Jan 2024 14:10:42 GMT

Hello!

I am looking for some help.

My data is monthly instead of daily values. I want the total sales in each row, but I am just getting the same sales value:

Total Sales Value = calculate(SUM('Table'[Sales]),ALL('Table'[Customer]))

What I want is:

Total Sales Value 18, 18, 18.

Here is my database table:

DateSalesCustomer

01.01.2020	5	Kevin
01.02.2020	6	Devin
01.03.2020	7	Levin

ie January, February, March.

It works when I am using daily sales values, but unfortunately the sales value for this project is only monthly. What can I do? Should I rebuild my database somehow? Sorry if this is too easy of a question, but I´ve read the documentation and cannot find out what is different with using monthly data.

Thank you

Corey

Re: Total Sales of Monthly data

Dangar332 — Tue, 16 Jan 2024 15:45:45 GMT

hi, Anonymous

try below measure

Total Sales Value = CALCULATE(SUM('Table'[Sales]),ALLEXCEPT('Table','Table'[DateSalesCustomer]))

Re: Total Sales of Monthly data

Anonymous — Wed, 17 Jan 2024 06:59:04 GMT

Hi Anonymous ,

Here are the steps you can follow：

1. Create measure.

Measure = var _sum= CALCULATE( SUM('Table'[Sales]),ALL('Table')) return SUMX( VALUES('Table'),_sum)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly