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