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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
bastik
Frequent Visitor

Measure or calculated using data from multiple tables

I have the model below and I want to calculate the capacity of each assignee based on the remaining days in a Sprint.

This would be basically Users[USER_DAILY_CAPACITY] * SPRINTS[DAYS_REMAINING_IN_SPRINT] but I can't seem to achieve this in DAX. 

 

I tried merging USER with SPRINTS using some intermediary tables and I can calculate the Remaining capacity per user, but with no direct relationship between SPRINTS and ISSUES doesn't bring the correct data if I filter with the Sprints_Reports.SPRINT_ID . 

 

bastik_0-1659502484001.png

 


Ultimately I want to display the Original Effort vs Remaining effort vs Remaining capacity per assignee and filter with Sprints_Reports.SPRINT_ID . 

 

Any ideas?

2 REPLIES 2
ValtteriN
Super User
Super User

Hi,

Since you have the information on how much capacity per spint there is I guess your issue is the inactive relationship which is required for aquiring "days remaining". You can activate this relationship by using USERELATIONSHIP in a DAX formula or alternatively by using variables e.g. something like this

[days remaining] =
var _sprintID = MAX(sprint_reports[sprintId]) return
CALCULATE(SUM(sprints[days_remaining]), sprints[sprintID] = _sprintID)

All in all, I recommend first creating measures to calculate [days remaining] and [user capacity] and then using these to create your final measure.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi, 

I already had the days remaining and capacity as measures, but still didn't manage to create a final measure. 

I'll return with a dummy PBIX in a couple of days to properly detail the issue. Thank you for your input!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.