topic Re: How do I use SUM to get all values of a table with the same company / item number as in the row? in DAX Commands and Tips

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

Niemeyer — Fri, 02 Sep 2022 09:13:45 GMT

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

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

tamerj1 — Fri, 02 Sep 2022 09:53:53 GMT

Hi Niemeyer
Best practice is to use a date table.

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

Niemeyer — Fri, 02 Sep 2022 10:32:09 GMT

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.

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

colacan — Sat, 03 Sep 2022 13:51:03 GMT

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)

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

Hope this helps. thanks

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

v-xiaotang — Tue, 13 Sep 2022 10:02:24 GMT

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.