Forum Discussion
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...
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!
Hi shelbsassy
Please find attached the modified pbix file.
https://1drv.ms/u/s!ApP3mBZyGaHfzxy447kb0wpU5XJI
Check the calendar table.
And the change in the Trended table.
Cheers
CheenuSing