Forum Discussion
Hierarchy Dim and Fact - Issues with Counts by level
Can you try dropbox, google or another file hosting? There is a bit of complexity here that could be hard to explain through words.
In the mean time, I will try to replicatein a demo file.
The Hierarchy Dim[ISSUE_ID] to FactTable[ISSUE_ID] is 1:1. I created the measure and set up the visual as explained. The Date table[Date] has a relationship to the FactTable{CreateDate]. I'm only receiving the total count. I'm not sure what I need to change. I thought I needed to filter the facttable using the the level in the the Hierarchy Dim.
When I drill dow to level 2, 235 is the correct count for level 1
When I drill down to level 3, 755 is the total count for level 1 & 2(235+520). Level 3 count is 98
- Tutu_in_YYC
Super User
How would you like to see the end result/visualization? Try drawing it out for us.
- Tutu_in_YYC
Are you able to share your pbix, you can remove any sensitive data first. At this moment, its hard to validate your numbers without knowing your data.
If you say 235 should be the total for level 1, but it is showing 853, it could mean that you have tickets that is not mapping to issue ID, or something else.
Dim[ISSUE_ID] to FactTable[ISSUE_ID] is 1:1
set this to 1:many (many at facttable)