cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

Visit my LinkedIn page by clicking here.

Schedule a meeting with me to discuss further by clicking here.

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.

Visit my LinkedIn page by clicking here.

Schedule a meeting with me to discuss further by clicking here.

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors