The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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] ) )
)
User | Count |
---|---|
161 | |
111 | |
96 | |
87 | |
75 |
User | Count |
---|---|
158 | |
136 | |
133 | |
81 | |
61 |