Forum Discussion

Simon_Br's avatar
Simon_Br
Icon for Helper I rankHelper I
3 years ago

Sum whit lookupvalue

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 ...
DAX
eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

hello Simon_Br  try the summarize functio

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