cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper V

## Use the value of a customer rank in a card visual

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.

Thanks for any ideas.

2 ACCEPTED SOLUTIONS
Super User

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"
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Helper V
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
3 REPLIES 3
Helper V
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
Super User

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"
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Helper V

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.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors