Forum Discussion

Wresen's avatar
Wresen
Icon for Post Patron rankPost Patron
6 years ago
Solved

Get 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...
Need Help
  • Wresen's avatar
    Wresen
    6 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Wresen , correct the table name at your end. It was Sheet1, last time

Wresen's avatar
Wresen
Icon for Post Patron rankPost Patron
6 years ago

Hi amitchandak 

 

I renamed Sheet1 to Table.

 

I am sorry but i do not get that code to work