In Power BI, how can you return the category label based on the max value for all categories returned by a measure using DAX?

Question

I want a DAX equation,and I want to return a text feild based on maximum returned by a measure which is applied over the filter

How can I do this?

Answer 1

Use the following measures:

newMeasure = 
    VAR vals = SUMMARIZE('Table', 'Table'[Column1], "myMeasure", [Measure])
    VAR measureMax = MAXX(vals, [myMeasure])
    VAR value = CALCULATE(MAXX(FILTER(vals, [myMeasure] = measureMax), [Column1]))
RETURN
    value  

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification