Rank by selection and grand total

[anandav]

Hi All,

I am trying to do some ranking of vendors based on sales.

As shown in the below image there are ttwo measures:

1] Rank Vendor by Selection

Rank changes based on what products are selected for the vendor in the 'produc Slicer'

2] Rank by Vendor $ Value

Ranks the vendor by grand total for the vendor (irrespective of what product is selected in the 'Product Slicer)'

These two measure work correctly when used independantly. But when they are put in the same table, then 'Rank Vendor by Selection' measure displays '1' for all rows.

I tired changing 'Rank by Vendor $ Value' to a column and still the same result.

Any help to sort this would be greatly appreciated.

Thanks,

Anand

[Phil_Seamark · Accepted solution]

Hi @anandav

Your [Rank Vendor by selection]  is using ALLSELECTED when perhaps you want to change it to ALL('DRM') like your other calculated measure.

The row header is filtering your RANKX function too heavily.

[anandav]

@Phil_Seamark,

Thanks a lot Phil. That works!

But I don't understand what do you mean by "The row header is filtering your RANKX function too heavily".

Would you be bale to shed some light on that please?