Insert Calculated Rows

paragraph — Wed, 05 Oct 2022 16:12:59 GMT

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!

Re: Insert Calculated Rows

serpiva64 — Wed, 05 Oct 2022 16:27:20 GMT

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 !

Re: Insert Calculated Rows

paragraph — Thu, 06 Oct 2022 14:42:22 GMT

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

topic Re: Insert Calculated Rows in DAX Commands and Tips

Insert Calculated Rows

Re: Insert Calculated Rows

Re: Insert Calculated Rows