Forum Discussion

shelbsassy's avatar
shelbsassy
Resolver 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
Resolver I
9 years ago

Using the Percent Measure Sean gave me yesterday as well as the Percent column, it is averaging in the measure but it is summing the column.  I removed aggregation from the ones that I could and this is what it shows me.  I am having a hard time filtering down to just that row of data so the PMPMP would be PMPM*1 for January and for February it would be PMPM *1.27.

 

This is my Percent Column calc

PercentColumn = CALCULATE(SUM(TrendCalcs[MonthDays])/sum(TrendCalcs[DataDay]),ALLEXCEPT(TrendCalcs,TrendCalcs[FirstDateC]))

shelbsassy's avatar
shelbsassy
Resolver I
9 years ago

I think I might have it.  I have been scouring msdns Dax library and tried this:

 

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

 

and I think it is doing what I want it to do. Fingers crossed!