Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have some issues on creating a DAX measure with multiple hierarchy level.
I have 1 table with unique client code and 4 hierarchy level.
Hierarchy 1 contains Hierarchy 2
Hierarchy 2 contains Hierarchy 3
Hierarchy 3 contains Hierarchy 4
Hierarchy 4 contains Client Code
I use the relations as descripted in the screenshot.
Each hierarchy level is connected to the main hierarchy table.
Then each one is connecting to the table with the values.
I am using this kind of relation because 'Code Hierarchy' in 'Table' can contain items from Hierarchy 1 or 2 or 3 or 4.
When i use drill on a simple graph with the 4 level and a simple measure like Average(Value), i don't get all the data. (i understand why)
I have tried some measures with ALL() / ALLSELECTED() / RELATED() / etc ... but it didn't work ...
Measure =
Hi @Bastaba
I don't understand the structure of your data. Could you provide some sample data to highlight what is causing you trouble? Or even better, create a sample report?
Cheers,
Sturla
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
23 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |