Insert Calculated Rows

[paragraph]

Hi, 

I would like to find a way to sum the value (Time) for two different Practices (merge two Practices into one, but also have the ability to keep Time for these two practice and use it in other charts).

I have two tables Practice and Task, in Task Table I have three columns (TaskID, Practice ID and Time) and the table Practice have columns (Practice ID and Practice), so I create a relationship by PracticeID.

To make it simple here is how it looks:

Practice	Time
RE	60
CORP	120
DP	40
M&A	20
LIT	50
ARB	25

And I would like to get this, but to leave the option to show both charts:

Practice	Time
RE	60
CORP	120
DP	40
M&A	20
DR (LIT + ARB)	75

This video best describes what I try to achieve:

https://www.youtube.com/watch?v=-t3DYRwsXgQ&ab_channel=Inforiver

Is it posible to do this by DAX or Power Query?

Thanks in advance!

[paragraph]

Thank you serpiva64! That's I was looking for.

[serpiva64 · Accepted solution]

Hi,

you can try using Groups

select your Column

group your values

and obtain your result

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !