Forum Discussion

analytics_ISFC's avatar
analytics_ISFC
Frequent Visitor
6 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
6 years ago
OK... So, why don't you calculate this in Power Query? This is, in fact, the place to do this.

Best
D
analytics_ISFC's avatar
analytics_ISFC
Frequent Visitor
6 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    With hierarchies, it's always tricky in Power BI. I think this is what you were asking for... Check the file attached.

     

    Best

    D

    • analytics_ISFC's avatar
      analytics_ISFC
      Frequent Visitor
      6 years ago

      the file is not opening 

       

      getting this error:

       

      Feedback Type:
      Frown (Error)

      Error Message:
      Object reference not set to an instance of an object.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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