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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi guys,
I'm quite desperate with a thing that it didn't seem to be that tricky.
I've made up a matrix with a FC estimation. The problem is that the subtotals are not correctly calculated. I believe that the confilct is linked with the formula that I've used :
Do you now how could I fix it up? I've been trying for two days with anyluck at all.
Kind regards,
Enrique.
using the following formula:
Hi mate,
I've just updated my post with the formula 🙂
Please share the formula. Can you share sample data and sample output. Thanks.
Proud to be a Datanaut My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
How could I share that info with you? I'm not finding the option "attach" or something like that. (I'm pretty new in PBI as you could see)
Try like this in sumx or averagex
averagex(summarize('Order intake',Date[Month year],"_Avg",IF(ISBLANK(Sales2020),DIVIDE(SalesLY + Sales2YearsAgo,2 ,0) * factor ,
DIVIDE(Sales2020 + SalesLY, 2, 0) * factor)),[_Avg])
Thanks for your response 🙂
I've just shared the formula that is working, but is not the case with the subtotals.
User | Count |
---|---|
97 | |
78 | |
77 | |
48 | |
26 |