Forum Discussion
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...
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
lazzarjovvch74 sorry I missed to mention that Call is a measure
Call = SUM ( HR[Calls] )
Max Hour =
CALCULATE(
MAX ( HR[Local Start Hour] ),
TOPN( 1, ALLSELECTED( HR[Local Start Hour] ), [Call], DESC )
)
