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.
For some reason, I could not share the .pbix
Here are the columns from the flattened hierarchy in the hierarchy table, which I duplicated from the fact which has the same parent child relationship.
These counts are implicit count aggregations from the hierarchy dimension, which I am attempting to use the relationship between the fact and hierarchy for these counts from the fact table. I thought I could create a measure using the hierarchy depth to filter the level counts.
I am trying to create visuals based on these different fields in the fact table by level. My measures have been incorrect and I am unable to filter the fact table by filtering the hierarchy table.