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...
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

One sample for your reference. Here I create a calculated table using the formula.

 

Table = SUMMARIZE(Table1,Table1[ID],"ID ",Table1[ID]&"="&SUM(Table1[VALUE]))

The result as below:

 

 

If it doesn't meet your requirement, please refer to Table2.

 

Table2 = SUMMARIZE(Table1,Table1[ID],"ID ",SUM(Table1[VALUE]))

For more details, please check the pbix as attached.

 

Regards,

Frank