Forum Discussion

Sarathg's avatar
Sarathg
Regular Visitor
3 years ago

How to know MAX CPM value

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?

Need Help

3 Replies

  • Arul's avatar
    Arul
    Super User
    3 years ago

    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's avatar
      Sarathg
      Regular Visitor
      3 years ago

      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.