Sum two rows to create a new row with new name

[Anonymous]

Hi Expert

I have a fact table which give me the following when field values are added to a standard table (AS-IS)

Grp_ID	Metric	£
a1	Sale	647
a2	Frieght Level1	520
a3	Feight Level2	45

I would to sum Grp_ID a2 +a3 to show that data as

a1	Sale	647
a2+a3	Total Freight	565

is it possible to the above using a DAX measure - my current measure is

Current Period =

IF (

TRIM ( FIRSTNONBLANK ( Grp_Sumry_Rep[Grp_Id], "" ) ) = "a2"

|| TRIM ( FIRSTNONBLANK ( Grp_Sumry_Rep[Grp_Id], "" ) ) = "a3"

[Sales],

blank())

I would like to add a2+a3 and create a new row called Total Frieght

[parry2k · Accepted solution]

@Anonymous this is what I will do to keep it simple, add new column:

New Group Id = 
IF ( Table[Grp_Id] IN { "A2", "A3" }, "A2+A3", Table[Grp_Id] )

New Metric = 
IF ( Table[Grp_Id] IN { "A2", "A3" }, "Total Freight", Table[Metric] )

In visual, use New Group Id, New Metric, and SUM of the amount and all should work as expected. 

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Thanks parry2k, let me apply that and report back with feedback.