Forum Discussion
Helper ICalculate the difference from the MAX value in a column
Community Champion
Helper IOK! I've got it!
So the solution here is a compilation of what PattemManohar and Fcoatis proposed. And here is what I did:
1. Created a new DAX table, where I put all the data I need as Columns.
1.1. I created a table where I used DISTINCT(Customer[Customer]) formula;
1.2. I added a new column: RevAnnual = [RevAnnual], which was a measure;
1.3. I then I used the formula which PattemManohar proposed. It took me good 2 minutes to figureout that it is Column, not Measure formula.
It works. Thanks everyone for the support. You're great.
- ganchevd
OK Now I have an issue when I try to use the same approach when the values are % I try to divide the profitability % by the MAX profitability % in a column. Same scenario but not with absolute values and the result is not the one I require.
Any suggestions?
- Fcoatis
Post Patron
Please send a sample of your data and the expected result.
Regards
- ganchevd
Basically the same scenario but with %
Customer Profitability % Ranking A 27.40% 0.61 B 25.80% 0.57 C 16.10% 0.36 D 13.60% 0.30 E 25.00% 0.56 F 36.00% 0.80 G 18.60% 0.41 H -24.90% -0.55 I 33.10% 0.74 J 22.80% 0.51 K -0.50% -0.01 L 7.60% 0.17 M 35.40% 0.79 N 8.30% 0.18 O 22.20% 0.49 P -11.20% -0.25 Q 24.10% 0.54 R 26.10% 0.58 S 25.30% 0.56 T 13.90% 0.31 U 21.50% 0.48 V 23.90% 0.53 W 25.70% 0.57 X 26.40% 0.59 Z 44.90% 1.00 AA 18.50% 0.41