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"

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I would like to have it as a measure instead as a additional column in the table.. The GroupBy Function also doesnt work, it doesnt add the values though I selected it.. 

  • 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.