Forum Discussion
Calculation change with drill down
Hi Community, I have to calculate percentage of principal outstanding at state and branch level but my denominator will change for State and Branch. My dax is not behaving correctly for State as...
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