Forum Discussion
Wresen
Post Patron
Post PatronGet highest value in Graph to use as line
Hi and thanks for reading this. I have a line and stacked column chart and i want to use the highest colum value to use in the line value I want it to be in a measure and the value for the line...
HI
I found a solution :
Measure 1:
Max2 = SUM('Table'[Value])Measure 2:Maxx = maxx(VALUES('Table'[Month]);[Max2])Measure 3 (modifid code that i got from v-lionel-msft )Max1 = CALCULATE( [Maxx]; ALLEXCEPT( 'Table'; 'Table'[Item] ); ALL('Table'[Month]))
amitchandak
Super User
Super UserTry with
Max =
var _1 = sumx(filter(table,table[item]="Lamp A"),Table[value])
var _2 = sumx(filter(table,table[item]="Lamp B"),Table[value])
return
max(_1,_2)
WresenPost Patron
Post Patron- amitchandak
Wresen , correct the table name at your end. It was Sheet1, last time
- Wresen
- amitchandak