Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sum based on unique ID

Hi Guys,   I have a problem which shouldnt be that difficult to solve, but I'm new to DAX and can't handle it.   What I am searching for is the Sum of values based on a ID.  Example: ID | V...
richardverburg's avatar
richardverburg
Helper I
7 years ago

If you put it in a table in PowerBI you get your results right? Why do you need it in an aggregated format? It will do it at "run time"

 

 

richardverburg's avatar
richardverburg
Helper I
7 years ago

Otherwise you can Add a table in PowerBI with the following DAX:

Table = SUMMARIZE(Sheet1; Sheet1[ID]; "Total Value"; sum(Sheet1[VALUE]))

This code will return an aggregated table.