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]))
     
Wresen's avatar
Wresen
Icon for Post Patron rankPost Patron
6 years ago

Hi v-lionel-msft

 

thanks so much ,but is it possible to get the highest value for the months , now it takes the total sum for all months.

So for Lamp A its will be 23 , and Lamp B  14

 

/Thanks

Wresen's avatar
Wresen
Icon for Post Patron rankPost Patron
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]))