Forum Discussion
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 columns that are fine with the default totaling. It's just these 2 columns.
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 )
5 Replies
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])
Hi griffinst
Thank you for reaching out to the Microsoft Fabric Forum Community.
Ashish_Mathur danextian cengizhanarslan Thanks for the inputs.
I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.
Hi griffinst
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.
