Forum Discussion
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...
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!
