Forum Discussion
analytics_ISFC
6 years agoFrequent Visitor
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...
analytics_ISFC
6 years agoFrequent Visitor
For this solution to work, branch and state should be in different tables. But I have them in the same table.
Anonymous
6 years agoNot applicable
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
https://www.youtube.com/watch?v=78d6mwR8GtA&t=1247s
Best
D
- analytics_ISFC6 years agoFrequent Visitor
Okay, thanks for the help