Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
DagmaraBI
Regular Visitor

How to show rank nr 1 value on card

Hello

 

I have this report, where I rank stores by revenue.

 

I have two tables
FactSales
DimStore

 

I have created measure calculating RANK, and I can see best performing stores 🙂 (Thanks to this community)

Now I need to show 1 THE BEST PERFORMING STORE on a card (right side of report)

 

How to achieve that?

 

I have tried using
calculate with first non blank, and cant get that right. 

 

Any help please?

Stores.JPG

1 REPLY 1
DataInsights
Super User
Super User

@DagmaraBI,

 

Try this measure:

 

Top Store = 
VAR vTopRow =
    TOPN ( 1, DimStore, [Revenue] )
VAR vResult =
    CALCULATE ( SELECTEDVALUE ( DimStore[Store_Name] ), vTopRow )
RETURN
    vResult




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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

Top Kudoed Authors