Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is there a way in a Power BI table to have a row at the bottom of the table that instead of showing the total of that column, shows the average of that column as shown below?
Solved! Go to Solution.
@Anonymous
You may use AVERAGEX to add a measure and take a look at Table & matrix total label customization.
Measure =
AVERAGEX ( VALUES ( 'Table'[Project] ), CALCULATE ( SUM ( 'Table'[Value] ) ) )
@Anonymous
You may use AVERAGEX to add a measure and take a look at Table & matrix total label customization.
Measure =
AVERAGEX ( VALUES ( 'Table'[Project] ), CALCULATE ( SUM ( 'Table'[Value] ) ) )
Try if this can work
Do Avg of sum at project level. Reverse of example give below. Sum till project level and then avg. It should change GT to Avg.
refer this - https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
Hold result in summarize till required level and the take avg of the measure post that.
Or using isfiltered change the calc. GT should change
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
The measure is not average and it is not even a measure. It is the actual total for each day for each product. There is no need to sum because there is only one result per day...but now that I think about it an average would give me the proper result for both since there is only one entry per day per project.
You just have to change the aggregation to average.
Regards