Customer Ranking at Company level to ignore all filters & slicers

[Anonymous]

Hi everyone,

I need to build a visual table with 2 types of customer ranking

1) Customer ranking at company level (not affected by sales rep slicer selection)

2) Customer ranking at each sales reps profile (follow the sales rep slicer)

In the table visual, 

Below is the example.

Thanks.

Regards,

SL

Sales Data Table
Customer Name	Product	Rep Name	P12M Sales
A	X	Alice	91753
A	Y	Adam	75071
A	X	Alice	60242
B	X	Alice	37779
C	Y	Adam	27500
B	Z	Mark	23633
C	Y	Adam	18536
* Slicer based on Adam
Table Visual:
Customer	Total Sales (co.)	Co. P12M Contribution	Co.Rank	Total Sales (base on slicer)*	P12M Contribution (base on slicer)*	Rank (base on slicer)*
A	227,066	68%	1	75071	62%	1
B	61,412	18%	2	0	0%	3
C	46036	14%	3	46036	38%	2

[amitchandak]

@Anonymous ,

if you need it, based on the slicer

rankx(allselected(Table[customer]),[Co. P12M Contribution])

not based on slicer

rankx(all(Table[customer]),[Co. P12M Contribution])

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415