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
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
3 years ago

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/