How to know MAX CPM value

Sarathg · ‎12-12-2022

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 · ‎12-12-2022

@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,

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Sarathg · ‎12-12-2022

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

Sarathg · ‎12-12-2022

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.