Forum Discussion

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

How to remove full table aggregation from a calculation for percentage

I have a calculated column that is taking the average of all data in the table but I just want to have the percentage by row.  Basically I am trying to divide DataDay by MonthDays for each mont...
Need Help
shelbsassy's avatar
shelbsassy
Icon for Resolver I rankResolver I
9 years ago

Awesome thank you, I got that to work.  However when I try to do the final calculation which is the Trended PMPM I am not getting that new column in my intellisense dropdown.

 

I need to calculate that [Percent Column] * [PMPM]

 

I have created both PMPM as a measure Members Claims[Total Paid]/Members Claims[# Members]

 

as well as a column PMPMC = 'Members Claims'[Total Paid]/'Members Claims'[# Members]

and I am trying to create Trended PMPM = [Percent Column]*[PMPM]

 

Can you see what I am doing wrong?

 

Thanks so much!

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

I suspect you don't like the results you are getting in the Total Row

Try these - all 3 are Measures

 

Percent Measure =
DIVIDE (
    SUM ( 'Members Claims'[DataDay] ),
    SUM ( 'Members Claims'[MonthDays] ),
    0
)

PMPM Measure =
DIVIDE (
    SUM ( 'Members Claims'[TotalPaid] ),
    SUM ( 'Members Claims'[# Members] ),
    0
)

Trended PMPM Measure = [Percent Measure] * [PMPM Measure]