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.
I want to calculate profitability
A. Sale
B. Cost
C. Profit = (A-B)
S.% Profit = ( A-B ) / A
I would have expected the summary to be the same,
but rather that it sums up instead of calculating a percentage.
Especially in collaps up situation
I have tried also this Show Values As => Percent of Row Total and all others
Thanks
Solved! Go to Solution.
Hello cs_skit
This is did not help (?)
But it did solve the problem
Average CUSTNAME = AVERAGEX(KEEPFILTERS(VALUES('INV-AMI'[CUSTNAME])),CALCULATE(AVERAGE('INV-AMI'[profit%]))
I donwt know why...
Still, I learned a lot
Thanks
for profit and percentage do measures instead of calculated columns then it works:
Hello cs_skit
This is did not help (?)
But it did solve the problem
Average CUSTNAME = AVERAGEX(KEEPFILTERS(VALUES('INV-AMI'[CUSTNAME])),CALCULATE(AVERAGE('INV-AMI'[profit%]))
I donwt know why...
Still, I learned a lot
Thanks