Forum Discussion

shelbsassy's avatar
shelbsassy
Icon for Resolver I rankResolver I
8 years ago
Solved

Percent column calculation not working as expected

I am trying to replicate a dashboard from scratch by copying the formulas and so far I have 2 issues where the formula is not working.  I posted what I thought would be a simple one here but it is ba...
Need Help
  • shelbsassy's avatar
    shelbsassy
    8 years ago

    I was able to create a measure using

    Percent Measure Trend = DIVIDE(SUM('Trend'[MonthDays]),SUM('Trend'[Data Day]),0)

    Then I got the amount:

    Trended PMPM = ROUND([Percent Measure Trend] * [Actual PMPM],2)

     

    Thanks for all the help!