Forum Discussion

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

How to create a measure from 2 columns using DIVIDE but needing a filter to get row context

I am trying to create a measure that I can get the Trended Per Member Per Month but the measure I have for Percent is not working.     I tried doing this measure:  Trended PMPM = ROUND((CALCULATE(...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    what is the relationship between table where you have your Actual AMPM Measure and table in which you have % column?

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

Ill have to create a dummy dashboard with data due to PHI info on this one.

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi shelbsassy,

Do you mind simplify your sample as Ashish_Mathur suggested? It's will be helpful to find a solution.

Best Regards,
Angelia