Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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:
Solved! Go to Solution.
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.
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.
@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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
34 | |
14 | |
14 | |
12 | |
9 |