Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
New Table =
ADDCOLUMNS(
SUMMARIZE(
'Old Awful Disgustingly Bad Table',
[ID],[Date],[Fruit],[Field],
"Amount",SUM([Amount]),
"Remaining",SUM([Remaining])
),
"Amt/Rem",DIVIDE([Amount],[Remaining],0)
)
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.
Hi @flyingmada
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)
New Table =
ADDCOLUMNS(
SUMMARIZE(
'Old Awful Disgustingly Bad Table',
[ID],[Date],[Fruit],[Field],
"Amount",SUM([Amount]),
"Remaining",SUM([Remaining])
),
"Amt/Rem",DIVIDE([Amount],[Remaining],0)
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |