Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I just want to get the sum of my average.
as you can see in the photo the total sum of my average is wrong.
The ave is the cost of every doc no.
In the measure I am trying to sum the cost of every doc no but getting wrong total.
Here is the link for the power bi report: Power BI test file
Thank you
Solved! Go to Solution.
hi, @mussaenda
This looks like a measure totals problem. Very common. See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
and for your case, just try this formula
Measure 3 = var _table=SUMMARIZE('Table','Table'[Posting Date].[Month],'Table'[Country Name],'Table'[Destination],'Table'[No_],"_avgsales", AVERAGEX('Table', 'Table'[Unit Cost (LCY)])) RETURN SUMX(_table,[_avgsales])
Result:
Best Regards,
Lin
Hi @mussaenda ,
I used the Quick Measure Like this:
Unit Cost (LCY) average per Destination = AVERAGEX( KEEPFILTERS(VALUES('Table'[Destination])), CALCULATE(SUM('Table'[Unit Cost (LCY)])) )
My output:
Let me know if this works:
Thanks,
Tejaswi
Hi @Anonymous,
Thank you for the time.
I tried your solution but it is giving me a wrong total at the end of the column.
I need the sum of average.
Average is the cost of every doc count column.
Do you know other ways?
hi, @mussaenda
This looks like a measure totals problem. Very common. See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
and for your case, just try this formula
Measure 3 = var _table=SUMMARIZE('Table','Table'[Posting Date].[Month],'Table'[Country Name],'Table'[Destination],'Table'[No_],"_avgsales", AVERAGEX('Table', 'Table'[Unit Cost (LCY)])) RETURN SUMX(_table,[_avgsales])
Result:
Best Regards,
Lin
Than you @v-lili6-msft !!
You don't know how much help you did to me.
I was so desparate with this problem.
I will surely review the links you gave.
Again, thank you so much! You helped me a lot!
You are so great!
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
69 | |
62 | |
55 |