Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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
User | Count |
---|---|
80 | |
77 | |
64 | |
48 | |
45 |
User | Count |
---|---|
103 | |
45 | |
39 | |
39 | |
36 |