Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |