- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Get related value to the max value of a measure column
Hey there!
I'm currently displaying multiple columns, all calculated by measures, in a table visual:
Product Name | Total Sales | Total Sales MoM | Total Sessions | Total Sessions MoM |
Product1 | 3000 | 50% | 200 | 42% |
Product2 | 4500 | -6% | 200 | 10% |
Those measures are stored in a measure table.
On a card visual for each MoM column, I want to display the MAX value of these columns and the respective "Product Name" as a description.
I already got a solution for showing the maximum number, although I'm not sure if this is the leanest solution:
First attempt with CALCULATE:
So how to achieve this with this setup?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous
The general pattern you can use for this is
Max Product Name =
MAXX(
TOPN(1, DimProduct, [Total Sales], DESC),
DimProduct[Product Name]
)
Here I'm using a [Total Sales] measure to get the top product but you can use any measure.
Similarly, I'm returning the Product Name here but you can change that to any dimension attribute/column you like.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous
The general pattern you can use for this is
Max Product Name =
MAXX(
TOPN(1, DimProduct, [Total Sales], DESC),
DimProduct[Product Name]
)
Here I'm using a [Total Sales] measure to get the top product but you can use any measure.
Similarly, I'm returning the Product Name here but you can change that to any dimension attribute/column you like.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous , You can use TOP 1
Top 1 = calculate(Max('DimProduct'[Product Name]),TOPN(1,allselected('DimProduct'[Product Name]),[Sales_TotalSales MoM%],DESC), values('DimProduct'[Product Name]))
In the bold max , you can have measure if you want top1 of any measure based on TOPN function

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
03-22-2023 11:06 PM | |||
07-03-2024 12:12 AM | |||
Anonymous
| 12-28-2023 06:37 PM | ||
03-01-2023 11:48 PM | |||
08-01-2024 12:48 AM |
User | Count |
---|---|
24 | |
13 | |
11 | |
10 | |
9 |
User | Count |
---|---|
18 | |
14 | |
14 | |
12 | |
11 |