Forum Discussion
Max from the Grid values
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
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.