Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
I got this data relations
I got 2 tables : tbl_CloudHardwareServices_trend and tbl_ConvergedHardwareServices_trend.
Inside the tables i got this rows:
IssuesTesting - IssuesInstallPlan- IssuesValidationPlan- IssuesRollBack - IssuesRollBackDecision - IssuesSchedule - IssuesType - IssuesTiming -IssuesDescription - IssuesApproval - IssuesOther - IssuesRiskAssessment - Date
i need to create a a visual, who sum all that row values for each table and have a date selector ( like you can see in the first image of the relation )
So i sum all the MAX values from each row, and was expecting that the relation filtered value works with a date selector, but this not work.
This is the Max SUM:
Issues ConvergedHardware = MAX('tbl_ConvergedHardwareServices_trend'[IssuesTesting] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesInstallPlan] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesValidationPlan] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesRollBack] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesRollBackDecision] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesSchedule] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesType] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesRollBackDecision] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesSchedule] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesType] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesTiming] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesDescription] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesApproval] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesOther] ) + MAX('tbl_ConvergedHardwareServices_trend'[IssuesRiskAssessment] )
Please, i need help.
Thank you!
Solved! Go to Solution.
Hi @Anonymous,
From your description, I could not figure out the “rows” you mentioned, it seemed the rows are all columns, right? If so, It could work on my side like the picture below:
1.I have entered some sample data:
2.MaxA = MAX([A])+MAX([B])
MaxB = MAX([C])+MAX([D])
3.Create two Card visuals and a slicer visual, add related field and you can see the correct result.
If I misunderstood you, could you please offer me more information about your data structure or share your pbix file if possible? Also you can test with our sample report on your side to see if the same issue occurs.
Regards,
Daniel He
Hi @Anonymous,
From your description, I could not figure out the “rows” you mentioned, it seemed the rows are all columns, right? If so, It could work on my side like the picture below:
1.I have entered some sample data:
2.MaxA = MAX([A])+MAX([B])
MaxB = MAX([C])+MAX([D])
3.Create two Card visuals and a slicer visual, add related field and you can see the correct result.
If I misunderstood you, could you please offer me more information about your data structure or share your pbix file if possible? Also you can test with our sample report on your side to see if the same issue occurs.
Regards,
Daniel He
Thank you!! your solution works like charm!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.