Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
paragraph
New Member

Insert Calculated Rows

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:

 

PracticeTime
RE60
CORP120
DP40
M&A20
LIT50
ARB25

 

paragraph_0-1664985684101.png

 

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

 

PracticeTime
RE60
CORP120
DP40
M&A20
DR (LIT + ARB)75

 

paragraph_1-1664985734122.png

 

 

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!

1 ACCEPTED SOLUTION
serpiva64
Super User
Super User

Hi,

you can try using Groups

select your Column

serpiva64_0-1664986900361.png

group your values

and obtain your result

 

serpiva64_1-1664987128777.png

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 !

 

 

View solution in original post

2 REPLIES 2
paragraph
New Member

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

serpiva64
Super User
Super User

Hi,

you can try using Groups

select your Column

serpiva64_0-1664986900361.png

group your values

and obtain your result

 

serpiva64_1-1664987128777.png

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 !

 

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors