Hi,
I have an issue with the MAX value formulas in Power BI. I use it quite simple in Excel but it is different in Power BI. So the Excel formula I use looks like: =C2/MAX($C$2:$C$27). which I use to measure all the customers to the one with highes revenue for me. Here is the sample table:
| Customer | RevAnnual | Ranking |
| A | 249 555 | 0.17 |
| B | 438 288 | 0.29 |
| C | 1 495 995 | 1.00 |
| D | 196 124 | 0.13 |
| E | 149 705 | 0.10 |
| F | 151 167 | 0.10 |
| H | 107 810 | 0.07 |
| I | 174 698 | 0.12 |
| J | 123 490 | 0.08 |
| K | 154 095 | 0.10 |
| L | 135 093 | 0.09 |
| M | 118 223 | 0.08 |
| N | 168 222 | 0.11 |
| O | 201 819 | 0.13 |
| P | 177 126 | 0.12 |
| Q | 695 892 | 0.47 |
| R | 145 866 | 0.10 |
| S | 283 475 | 0.19 |
| T | 158 290 | 0.11 |
| U | 307 196 | 0.21 |
| V | 114 665 | 0.08 |
| W | 218 940 | 0.15 |
| X | 134 489 | 0.09 |
| Y | 227 215 | 0.15 |
| Z | 117 036 | 0.08 |
| AA | 210 760 | 0.14 |
In the attached table the RevAnnual is a Measure column in my report. Can someone help me figure out how to do this? Thank you in advance
