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.
Super UserIn both dimension and fact, there will be a column that has the same key. It is unique. Its probably the same key that you use to create Level1/2/3 columns and the path ie. flattening the parent-child hierarcy.
Find that primary key of the dimension,create a relationship using that key column, and that should be all you need, just that one relationship.
In visualization, use the column Level1/2/3 to break down your measure.
Attached is a sample.
Thank you for comfirming that the hierarchy table should only need the one relationship Hierchary[ISSUE_ID] and Fact[ISSUE_ID]. From you pbix, I could not determine how to create a measure for each level to count the number of issues by item type in the fact table.
- Tutu_in_YYC
You dont have to create a measure for each level. Just 1 measure, in your case is probably DISTINCTCOUNT(FactTable[Issue_ID])
And use the measure in the Values bucket of the matrix