Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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?
Try this measure:
Top Store =
VAR vTopRow =
TOPN ( 1, DimStore, [Revenue] )
VAR vResult =
CALCULATE ( SELECTEDVALUE ( DimStore[Store_Name] ), vTopRow )
RETURN
vResult
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
15 | |
11 | |
10 | |
10 |