Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |