How to know MAX CPM value

[Sarathg]

Hi Guys,
I have 50 states and there are 40 spend & CPM records for each and every state. so i add those spend & CPM for every state now i need MAX CPM. I try to calculate with different functions but the result is like the below screenshot.
Can anyone help me with this?

[Arul]

@Sarathg,

Is this your expectation? I have taken sample from the screenshot attached and worked based on that.

MAX CPM = 
CALCULATE(MAX('CPM Table'[CPM]),ALL('CPM Table'))

Thanks,

[Sarathg]

Is there any other way to solve it????

[Sarathg]

Hi Arul,
I have done that also but i am not getting the answer that you got because i have multiple states in single state like i have 40 Alabama states i did add spend and cpm to get only one state after that i did right the same DAX that you given. Can you please look below screenshot once. Thank you.