Forum Discussion
Calculation change with drill down
With hierarchies, it's always tricky in Power BI. I think this is what you were asking for... Check the file attached.
Best
D
the file is not opening
getting this error:
Feedback Type:
Frown (Error)
Error Message:
Object reference not set to an instance of an object.
It does open on my side without a problem. I just click the file, it gets downloaded and it opens in PBI Desktop without a glitch.
Here's what's in the file:
Is this what you wanted?
I attach the file again but the first link is working correctly as well.
Best
D
I used your solution but it showing 100% for all the scenarios.
When i apply any filter, the value should change, but this is not happening.
- Well, the calculation is relative to what's been selected. If you want an absolute calculation, you have to change the measure.
Best
D That is where i am stuck. i dont know how to proceed with it. i want my calculations to change dynamically with applied filter.
Check out this final version. It has 2 measures. One that's relative to the selection in the slicer---% Parent (rel)---and another one that's absolute---% Parent (abs). One of them is the one you want.
Best
D
For this solution to work, branch and state should be in different tables. But I have them in the same table.
- If you do have them in the same table, then you should change it. Please try to learn something about proper dimensional design:
https://www.youtube.com/watch?v=78d6mwR8GtA&t=1247s
Best
D Okay, thanks for the help