Max value based on conditional measure

[Krishnaraj]

Hello, 

In the following data, I am trying to get the max Maturity Level ID where Assessment Criteria # = Assessment Criteria Met #. Both Assessment Criteria # and Assessment Criteria Met # are measures and they are the counts of total criteria and criteria that were met respectively. 

For Benefits Determination, Business Context, Access and Authorization, I am expecting Current ML to be 4. As that is the Max maturity level ID when Assessment Criteria # and Assessment Criteria Met # match (3=3). 

Please help. 

[Anonymous]

Hi @Krishnaraj,

Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@Krishnaraj , Try a measure like

maxx(filter(summarize(Table, table[use case name], table[plan name],table[elemet name], "_1",[ Assessment Criteria #], "_2" , [Assessment Criteria Met #], "_3",[Maturity Level ID]), [_1] =[_2]),[_3])