Cusotmers ranking at company Rank level versus individual rep level in the same table visual

[Anonymous]

Hi all,

I am facing an issue to do both company level ranking & individual level ranking for the customers in one table visualization.

Co Rank will not be affected by the "Rep Name" Slicer.

Individual Rank will change according to the "Rep Name Slicer"

EG:

Sales Data
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

Is there any DAX that I can omit the slicer or any other way to do it? I tried ALL funtion but it doen't help when I select Adam for Eg., the co. ranking still follow the slicer. As I understand, the edit Interactions is working on the entire table, am I right? Can I edit interactions by Column choice?

Thanks.

Regards,

SL

[v-chuncz-msft]

@Anonymous 

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/Using-RANKX-with-Filtered-Column/m-p/1017680#M481010

[Anonymous]

Ok, thanks for the heads up.