Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello,
as you can see, the total sum is wrong
i want to sum of my average data
here is the file : https://drive.google.com/file/d/1JErU8xK8xG49hoN2t0tX2MgI5DPZF3N1/view?usp=sharing
Please help,
thank you
Ps: sorry for my language
Solved! Go to Solution.
@prapatsornchar
You can create a measure as follows:
Avg Inventory =
IF(
ISINSCOPE( Sheet1[Sec]),
AVERAGE( Sheet1[inventory] ),
SUMX(
VALUES( Sheet1[Sec] ) , CALCULATE( AVERAGE( Sheet1[inventory]))
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you so much, i really appreciate for you help
@prapatsornchar
You are just averaging the Invetory column so at the total level, it returns the average of the complete table.
What sort result do you want to calculate for the total row?
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
yes, i use average formula for inventory column
but i want sum it
from the picture, i want total number to be 21,076.4
(1882+274+1689+337+500+456+118+983.4+381+1265+1101+12090=21076.4)
@prapatsornchar
You file cannot be accessed
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
can you try again?
i already set share option on my google drive
@prapatsornchar
You can create a measure as follows:
Avg Inventory =
IF(
ISINSCOPE( Sheet1[Sec]),
AVERAGE( Sheet1[inventory] ),
SUMX(
VALUES( Sheet1[Sec] ) , CALCULATE( AVERAGE( Sheet1[inventory]))
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.