Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 73 | |
| 50 | |
| 46 | |
| 44 |