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...
analytics_ISFC's avatar
analytics_ISFC
Frequent Visitor
6 years ago

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!

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?