cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kirkademidov Frequent Visitor
Frequent Visitor

Problem with calculation of total on different hierarchy levels

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. 

 

Capture.PNG

 

 

 

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. 

Link to PBI Solution

 

Please, anyone I really need advise - I`m trying to figure out in almost 3 weeks!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Problem with calculation of total on different hierarchy levels

@kirkademidov,

 

You may try a similar way as shown in post below.

https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Problem with calculation of total on different hierarchy levels

@kirkademidov,

 

You may try a similar way as shown in post below.

https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.