Forum Discussion
Problem with relation between diferents tables and dates
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!
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
2 Replies
v-danhe-msftMicrosoft Employee
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