cancel
Showing results for
Did you mean:
Frequent Visitor

## Summing Values from one Table based on Unique ID

I would like to sum multiple values from one table based on a unique ID and create a new table with this information. Then, I need to create a calculated column with the new information. Example is below. 1 ACCEPTED SOLUTION Super User IV

``````New Table =
SUMMARIZE(
[ID],[Date],[Fruit],[Field],
"Amount",SUM([Amount]),
"Remaining",SUM([Remaining])
),
"Amt/Rem",DIVIDE([Amount],[Remaining],0)
)``````

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

3 REPLIES 3 Super User III

Hi,

To your visual, drag the first 4 fields to your Table visual and write these measures:

Total amount = SUM(Data[Amount])

Remaining amount = SUM(Data[Remaining])

Amount/Rem = [Total amount]/[Remaining amount]

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com Super User II

I have a slightly different solution to @Greg_Deckler : ``````New Table =
SUMMARIZE (
'Table',
'Table'[ID],
'Table'[Date],
'Table'[Fruit],
'Table'[Location],
"Amount", SUM ( 'Table'[Amount] ),
"Remaining", SUM ( 'Table'[Remaining] ),
"Amt/Rem", DIVIDE ( SUM ( 'Table'[Amount] ), SUM ( 'Table'[Remaining] ) )
)``````

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut) Super User IV

``````New Table =
SUMMARIZE(
[ID],[Date],[Fruit],[Field],
"Amount",SUM([Amount]),
"Remaining",SUM([Remaining])
),
"Amt/Rem",DIVIDE([Amount],[Remaining],0)
)``````

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!   