Forum Discussion

dd321's avatar
dd321
Frequent Visitor
7 years ago
Solved

Filter with multiple relationship

Hi all,   I'm currently using PowerBI to visualize values in my local database using Direct Query. Example of my entities (simplified, not real entities in my database) but illustrates the relation...
Need Help
  • tex628's avatar
    tex628
    7 years ago

    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! 

selsor's avatar
selsor
Frequent Visitor
7 years ago

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.

 

  • dd321's avatar
    dd321
    Frequent Visitor
    7 years ago

    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?

    • selsor's avatar
      selsor
      Frequent Visitor
      7 years ago

      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.

       

       

      • dd321's avatar
        dd321
        Frequent Visitor
        7 years ago

        Sorry, there is a foreign key from Student to University, missed it on my database diagram.