Rank Customers Sales by Location

Question

Hello Good people,&nbsp;I have read quite a lot of questions/posts of&nbsp; similialr to scenario and couldnt' get the answer. My case is as per below,&nbsp;I have a table which includes client, contract location, and ITO(sales). see sample. I want to come with visual that will rank customer's ITO as per table( see example)&nbsp;Customer TableHow the ranking should beBased on the selected customer, we would like to seeTheir contracts location, the total ITO(Sales) for that contract location and the total number of customers that have the same contract as the selected customer and mostly importantly&nbsp; the rank to compared to others for that contracts location.&nbsp;Currently this is what I have&nbsp;&nbsp;&nbsp;Thanks in advance.&nbsp;&nbsp;&nbsp;

amitchandak · Answer

MarmosspinneBW , based on what I got . assume total_ITO is a measure 
&nbsp;
rankx(allselected(Table[contract location]) ,[total_ITO],,dese, dense)
&nbsp;
above will use filters
&nbsp;
this will not
rankx(all(Table[contract location]) ,[total_ITO],,dese, dense)
&nbsp;
For Rank Refer these linkshttps://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measureshttps://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

marmosspinnebw · Answer

amitchandak&nbsp;Thanks !&nbsp;I have managed to rank with the first formalar as shown in my qestions. I have to rank also based on the contract location for that selected customer. Your suggestion only gives us the same rank.. see below&nbsp;&nbsp;