Forum Discussion

paa_paa's avatar
paa_paa
New Member
8 years ago
Solved

Get value from another column using MAXX

Hi there,   I have a measure that (1) creates a table, and (2) returns the max value for that table. It looks something like this:   measure = maxx(summarize('Table1','Table1'[Area],"Sales",[Sale...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    paa_paa

     

    Give this a shot as well.

    [Measure] is the measure you created which gets you maximum sales

     

    Region with Max Sales =
VAR maxsales = [measure]
RETURN
    CALCULATE (
        FIRSTNONBLANK ( Table1[Area], 1 ),
        FILTER ( ALL ( Table1[Area] ), [Sales] = maxsales )
    )

     

paa_paa's avatar
paa_paa
New Member
8 years ago

Thanks to both!

 

I ended up using Zabair's solution, but probably both of them work, as from what I could gather they both use the same concept (filter the table for the value)

 

 

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Zabairs one was pretty much a copy of mine.  Not sure why he replied when I had already provided a more efficient solution that didn't require a calculate.