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
This does not look to be a measure. It's a calculated column, right?

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

yes.

Measure is throwing a different result altogether.

  • 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