Use the value of a customer rank in a card visual

[johnmelbourne]

I have a table visual with the following values .... and I want to place the rank of Customer A in a card. That is, the number 2. 

However, obviously when I filter for the customer, it only has one row and therefore ranks 1. 

I want to return the rank of customer A in the content of all the customers. 

PBIX link: 

https://drive.google.com/file/d/1WuEalnD65nIrCjJJNV95TAnWp6hN7QdW/view?usp=share_link

Thanks for any ideas.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

I think, in this case, you can try to use ALL, instead of using ALLSELECTED.

Rank solution =
IF (
    HASONEVALUE ( Customers[Customer] ),
    IF (
        NOT ( ISBLANK ( [Total sales] ) ),
        RANKX (
            FILTER ( ALL ( 'Customers'[Customer] ), NOT ( ISBLANK ( [Total sales] ) ) ),
            [Total sales]
        )
    ),
    "select one customer"
)

[johnmelbourne · Accepted solution]

SOLUTION:

Rank of customer =

var _tVisibleCustomers =

    CALCULATETABLE(

        FILTER (

            ALLSELECTED ( 'Customers'[Customer] ),

            NOT ( ISBLANK ( [Total sales] ) )

        ))

VAR _sResult = CALCULATE( RANKX( _tVisibleCustomers, [Total sales],,DESC,Dense), Customers[Customer] = "A")                  

Return

_sResult  

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

I think, in this case, you can try to use ALL, instead of using ALLSELECTED.

Rank solution =
IF (
    HASONEVALUE ( Customers[Customer] ),
    IF (
        NOT ( ISBLANK ( [Total sales] ) ),
        RANKX (
            FILTER ( ALL ( 'Customers'[Customer] ), NOT ( ISBLANK ( [Total sales] ) ) ),
            [Total sales]
        )
    ),
    "select one customer"
)

[johnmelbourne]

Brilliant @Jihwan_Kim !  I didn't think of ALL. 
Thank you @Jihwan_Kim.  I had a solution, but wanted exactly what you gave me. You took it that extra step that I needed and made it dynamic. I like the HASONEVALUE error message solution as well. 
Many thanks.