Sum whit lookupvalue

[Simon_Br]

Hello,  

I have the challenge with the Dax formula. I want a new table that contains only the total from the detail table.

Example:

Produkt	Cost
A	50
B	60
C	4
A	55
B	75
C	245
A	188.6
B	219.2
C	249.8
A	280.4
B	311
C	341.6
A	372.2
B	402.8
C	433.4

A	946.2
B	1068
C	1273.8

We can i this do it? I trying whit lookupvalue +sum, but no sucess.

Can anyone help me with this? Many thanks in advance!

Simon

[Simon_Br]

Thank for the answer. We function the code, when the code one existing table paste?

Example:

Category	Produkt	Cost
Car	A	946.2
Train	B	1068
Bike	C	1273.8

Simon

[ValtteriN]

Hi,

Try this:

Table 2 = SUMMARIZE('Table','Table'[Produkt],"SUM",SUM('Table'[Cost]))

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[eliasayyy]

hello @Simon_Br  try the summarize functio

New Table = SUMMARIZE('Table','Table'[Produkt],"Total Cost",SUM('Table'[Cost]))