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 I drill up. it is keeping denominator of branchname.
My DAX is:
I have been stuck at this problem for a very long time and it is highly important for me to find a solution. Any help would be appreciated.
Thanks in advance!
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?
the file is not opening
getting this error:
Object reference not set to an instance of an object.
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.
That is where i am stuck. i dont know how to proceed with it. i want my calculations to change dynamically with applied filter.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.