Total Sales of Monthly data

[Anonymous]

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

[v-yangliu-msft]

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

[Dangar332 · Accepted solution]

hi, @Anonymous 

try below measure

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