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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Sum & Filter value from another Column with UserRelationship

I have two columns  Training Hours & Training Overdues

 

Training Hours     

Course 

Month

Date

No. of Trainees

 

Training OverDues

Course

Month

No, of OverDues

 

I want to calculate no of Overdues for Participants per month . I have following measure, its showing the total overdues for each course. I want to display the filter the results when selecting month from Timeline Visuals

 

Course to Course relation is active but month is not because its link with other tables 

 

Measure = CALCULATE(SUM(Training OverDues[Over Dues]),USERELATIONSHIP(Training OverDues[Month],'Training Hours'[Month]),USERELATIONSHIP(Training OverDues[Course],'Training Hours'[Course]))
 
 
2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

Share some data and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Based on your description, I created some sample data. Please find sample file and pbix file.

 

https://1drv.ms/u/s!Ai0GzdHCLgzPkkC3vOPWBm6a7y_x?e=K1cQXq

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.