Forum Discussion
Simon_Br
Helper I
Helper ISum 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 | 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
3 Replies
- ValtteriN
Community Champion
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/ 
Simon_BrThank 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
