This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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 April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 37 | |
| 28 | |
| 28 | |
| 19 | |
| 18 |
| User | Count |
|---|---|
| 69 | |
| 38 | |
| 32 | |
| 28 | |
| 24 |