sum of 2nd highest values for each state, and then sum that values

[Maria_Buzaglo]

Hi,

How can I do the following DAX formula:

I want to sum the 2nd highest values for each state. 

Ex:

Thanks,

Maria uzaglo

[Jihwan_Kim · Accepted solution]

Hi, @Maria_Buzaglo 

Please correct me if I wrongly understood your question.

Please check the below picture and please let me know if it is what you are looking for.

Also, check the link down below, and it has all the related measures.

https://www.dropbox.com/s/tpllr9iramknpnw/Maria%20Buzaglo%202021%200327.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help the other members find it more quickly.