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 UserMax =
var _1 = calculate(sum(value),table[item]="Lamp A")
var _2 = calculate(sum(value),table[item]="Lamp B")
return
max(_1,_2)
WresenPost Patron
Post PatronHi amitchandak
Thanks so much for the suggestion, but i dont think i works, the max value for Lamp A (in this case) should be a straigh line and the max value is in Feb and is 23 , so the line should be 23 for all months.
And i will have over 1000 items in the total file.
- amitchandak
Try 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)- Wresen
- amitchandak
Wresen , correct the table name at your end. It was Sheet1, last time