Forum Discussion
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 bu...
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,
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.