Need RANKX to ignore Legend/Columns on visualizations

Hi NewAnalyst16 ,

The use of measures is based on context meaning that the calculation is done based on the filters, columns, visualizaitons, interactions and so on, however you can overcome that by adding the ALL syntax for example has you did.

However in this case since you are adding a new column to your visualization you need to add it to the RANKING measure.

Please check this blog post with an explanation about the use of RANKX with several levels of detail:

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

If you still need assistance with the calculation please tell me, and if please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.