Forum Discussion
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
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
- Ashish_Mathur
Super User
Hi,
Share some data and show the expected result.
