Forum Discussion
Filter with multiple relationship
Doublecheck the data type on GradeValue.Value and make sure that it's still INT.
If it's int take a look in the visualizations pane and make sure that "Sum" is selected on the settings for GradeValue.Value.
This is definitly an issue with dataformatting of some sort. Power BI defaults to aggregation when you have numeric columns so you should never have a scenario like the one you're describing!
you can merge grade and gradeValue tables with power query.
and control relation's way between gradeValue and student and university.
Maybe u should set both way one of them.
Hi selsor ,
Thanks for your reply.
I know I can merge them, but whenever I click on a specific student, the grade description and type disappears.
Control relation's way between GradeValue and Student and University, meaning?
i couldn't see foreign key between university and student.
i think u have original tables.
so when u set relation to tables, it gives u a way single or both.
pls try both way between ur tables.
Sorry, there is a foreign key from Student to University, missed it on my database diagram.
This is quite hard to resolve, from the information that you have provided there is actually no reason as to why your datamodel shoudnt work.
But in my opinion it sounds like it's the link between Grade and Gradevalue that is bad. Could you possibly take a look and make sure that the relationship there is working as intended?