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 )
    )

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi paa_paa

 

I think this measure gets close

 

Measure2 = 
VAR myGrouping = SUMMARIZECOLUMNS('Table1'[Area],"Grouped Sales",SUM('Table1'[Sales]))
VAR myMaxValue = MAXX(myGrouping,[Grouped Sales])
RETURN 
	MAXX(
		FILTER(
			myGrouping,
			[Grouped Sales] =myMaxValue) ,
			[Area]
			)
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    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 )
    )