How do I use SUM to get all values of a table with the same company / item number as in the row?

[Niemeyer]

Hello

I need help with the SUM function in Measures.

I have a table with the following fields:

Company
Item number
Value

No matter how or what I filter, all values in a column should be summed to the article / company that is displayed in the row.

This does not work, I still get only the value in the row back

VAR Value_1 = CALCULATE (
SUM ( Table[Value] ),
ALL(Table[Value]),
Table[Date] >= Date_1,
Table[Date] <= Date_2)

I have already tried with ALL, but I can't get any further. This one does not work.

Best Regards
Volker

[tamerj1]

Hi @Niemeyer 
Best practice is to use a date table.

[Niemeyer]

One more note: I am showing data from Table 1. The sum of the values comes from table 2, which is linked via company and article number.

[colacan]

@Niemeyer Hi Niemeyer,

among filters, ALL(Table[Value]) is not clear. just delete [Value] and try with ALL(Table).

If you just want to filter dates for your sum value (article / company will be filted by the visual)
then you can try
either 

VAR Value_1 = CALCULATE (
SUM ( Table[Value] ),
ALL(Table),
Table[Date] >= Date_1,
Table[Date] <= Date_2)

OR

VAR Value_1 = CALCULATE (
SUM ( Table[Value] ),
FILTER(Table, Table[Date] >= Date_1 && Table[Date] <= Date_2)

Hope this helps. thanks

[v-xiaotang]

Hi @Niemeyer 

Thanks for reaching out to us.

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

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