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!
At the moment no, but most likely I can have it if I tweak my database. Would that help if that's the case?
Nevermind that last post,
It should be the the Gradevalue.value column that is causing the duplicate values since it can occur more than once for each row in Grade.
But it still shouldn't display complete duplicates in a table... are the Gradevalue.value also duplicate values or is it only Type/Description?
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.
GradeValue.value can have duplicate values as multiple students can have the same grade.
One thing I noticed is that Table 3 which has following columns:
- GradeValue.Value (int)
- Grade.Type (varchar)
- Grade.Description (varchar)
If NOTHING is selected, I get duplicate of type/description but NOT value. However, if I have add in fk_student_id from GradeValue table, then I get duplicate values of both type, description AND value.
Example 1:
Table 3 with only type, description, value, the result when nothing is selected:
Description | Type | Value
duplicate | duplicate | 0
duplicate | duplicate | 1
duplicate | duplicate | 10
Example 2:
Table 3 with type, description, value, AND fk_student_id, the result when nothing is selected:
Description | Type | Value
duplicate | duplicate | 0
duplicate | duplicate | 0
duplicate | duplicate | 0
duplicate | duplicate | 1
duplicate | duplicate | 1
duplicate | duplicate | 10
duplicate | duplicate | 10
What I ultimately want (when nothing is selected):
Description | Type | Value
text1 | text2 | total sum of values
text3 | text4 | total sum of values
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!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