Forum Discussion
Solved
custom total row
I'm converting excel reports into power bi. One issue is for the totals column these two need a different calculation. The sum that power bi is doing isn't what I want. The table has several other...
Power BI totals are not simple sums, they re-evaluate the measure in total context. To fix the Total you need to use a different measure logic instead on simple aggregation like:
PMPM Trend % = IF( ISINSCOPE(YourTable[Category]), -- row level [Your Row Calculation], [Your Custom Total Calculation] -- total logic )
Hi,
What happens when you write this measure
Avg = average(Data[column name])