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.
Hello,
I have a Grid
Colum 1 -------- Sum of Sales Amount (its a SUM measure)
Product A -------- $100
Product B -------- $300
Product C -------- $50
Product D -------- $450
Product E -------- $100
I need to show in a Card as a seprate visual
$450
Which is the max of all product sales
Thanks
Solved! Go to Solution.
Hi @sabeensp,
Based on my test, you could refer to below formula:
Measure = MAXX('Table1','Table1'[Sum Measure])
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi @sabeensp,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Hi @sabeensp,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Hi @sabeensp,
Based on my test, you could refer to below formula:
Measure = MAXX('Table1','Table1'[Sum Measure])
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Assuming you have a fact table that has products and prices like this:
Product Price
A 200
A 200
A 50
B 100
B 100
C 70
C 80
you could try something like this:
Max Product Price = var __table = SUMMARIZE(Table1, Table1[Product], "Price", SUM(Table1[Price])) return MAXX(__table, [Price])
Essentially, I'm just summarizing the fact table to group up the product column, and aggregate (sum) the price column, and then returning the max of that price column.
Hopefully this helps.
Hi @sabeensp
Try this for your measure in the Card visual:
CardMeasure =
MAXX (
SUMMARIZECOLUMNS ( Table1[Column] );
CALCULATE ( SUM ( Table1[Sales Amount] ) )
)
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |