cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rikkijp Frequent Visitor
Frequent Visitor

Difference between columns on two measures

I know that this is what I think is entry level.... I'm sure I learned it in the training course I took but just can't seem to muscle through it and everyone here is always so helpful!

 

I have a few tables in my data:

1) sharepoint odata link to a list with all of our project work including a choice column for "Teams"

2) Team Name table used as a connector between the other tables

3) Capacity table with team name and their capacity by quarter

4) date table used to cross reference dates accross the tables

 

I have a bar chart that has the capacity by team for quarter 1, clustered with the total of projects with a status "in progress" by team - filtered by quarter 1 (pic below)

 

I want to figure out how to create a table or matrix to numerically say the difference between capacity and work in progress - i.e. a specific team is 4 over utilized or 4 under utilized.

capacity.png

 

2 REPLIES 2
Microsoft v-jiascu-msft
Microsoft

Re: Difference between columns on two measures

Hi @rikkijp,

 

Can you share a dummy sample data please?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ElliotP Member
Member

Re: Difference between columns on two measures

It looks like you're using Count() to sum the number of ID's, I would guess maybe for case issues between areas for example.

 

You could try creating a measure which SUM()'s the [id] column and then a Capacity-SummedID measure.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors