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...
yes.
Measure is throwing a different result altogether.
OK... So, why don't you calculate this in Power Query? This is, in fact, the place to do this.
Best
D
Best
D
State and Branch are reference columns and you cant see them in Power Query.
I dont know how this can be written in Power query.
Is there a way you can help in write a calculated column or calculated measure that would help me achieve my objective?
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.