Forum Discussion

lazzarjovvch74's avatar
lazzarjovvch74
Helper I
6 years ago
Solved

Retrieve single column value based on calculation on another column

Hello,   This is my Power Bi table where the column "Calls" is calculated column ( a kind of counter). I want to get Local Start Hour when the highest number of Calls were started for a selected na...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Perhaps:

     

    Measure 3 = 
    VAR __Name = MAX('Table7'[Name])
    VAR __Table = SUMMARIZE('Table7',[Name],[Local Start Hour],"__Calls",SUM([Calls]))
    VAR __Max = MAXX(FILTER(__Table,[Name] = __Name),[__Calls])
RETURN
    MINX(FILTER(__Table,[Name] = __Name && [__Calls] = __Max),[Local Start Hour])

     

    Page 5, Table 7

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Perhaps:

 

Measure 3 = 
    VAR __Name = MAX('Table7'[Name])
    VAR __Table = SUMMARIZE('Table7',[Name],[Local Start Hour],"__Calls",SUM([Calls]))
    VAR __Max = MAXX(FILTER(__Table,[Name] = __Name),[__Calls])
RETURN
    MINX(FILTER(__Table,[Name] = __Name && [__Calls] = __Max),[Local Start Hour])

 

Page 5, Table 7