Forum Discussion

shelbsassy's avatar
shelbsassy
Icon for Resolver I rankResolver I
9 years ago

Rounding is not working

I have a measure that I created for the trended PMPM which is 

 

Trended PMPM = (CALCULATE('Members Claims'[PMPM To Date]) * [Percent Measure](FILTER(TrendCalcs,[FirstDate])))

 

Even though I have decimal with 2 places selected it is showing up on the gauge with many digits.  I tried using the round function but that did not do anything.  I can't create a column because theres a circular dependency?

 

Does anyone have any ideas?  Also it would be great if the gauge would show $ signs but I cant seem to find that in the formatting.

 

Thanks!

Need Help

5 Replies

    • shelbsassy's avatar
      shelbsassy
      Icon for Resolver I rankResolver I
      9 years ago

      I tried Trended PMPM = ROUND((CALCULATE('Members Claims'[PMPM To Date]) * [Percent Measure](FILTER(TrendCalcs,[FirstDate]))),2) but it did not do anything.  On this particular tab of the dashbaord for this Plan, it is the only one that it has that problem.  When I looked at other tabs and changed the round to a 0 spaces it did change to just 470 but when I put the ,2 back it comes out with that long string again but not on the other tabs.  I am just trying to get this down to 2 decimal places.