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! 

dd321's avatar
dd321
Frequent Visitor
7 years ago

Thank you, that was it! I thought it was an int but my migration specified it as a varchar. Now it works as intended! Thanks for the help! Marked as solution.

tex628's avatar
tex628
Community Champion
7 years ago

Glad to hear it! 

When it comes to calculated measures and columns i would simply recommend misrosoft's own help site:
https://docs.microsoft.com/en-us/dax
It's atleast what i use when i need to look something up :-) 

Br,
Johannes