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 all,
I need help to find DAX solution in some hierarchy issue.
I have a model with 3 level hierarchy: Question, Model and Category Model.
I need to get some value on level of Category Model (highest level of hierarchy) which is simple sum of values on second level but it dosnt work.
On the highest level I need simple sum of RelativeEstimated by the relative weight of model from second level of hierarchy but I`m getting 1 instead of 71.04 (17.81+26.93+26.30)
Where is quite complicated measure to get Total Score on the second level but I can not implement it third level.
Please, anyone I really need advise - I`m trying to figure out in almost 3 weeks!
Solved! Go to Solution.
You may try a similar way as shown in post below.
You may try a similar way as shown in post below.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |