Forum Discussion

shelbsassy's avatar
shelbsassy
Resolver 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!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi shelbsassy,

 

For your scenario, I think it may due to the conflict of internal filter and the current filter in the formula.

Can you please share the sample pbix file for test? 

 

Regards,

Xiaoxin Sheng

shelbsassy's avatar
shelbsassy
Resolver I
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!