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

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Wresen ,

 

Yes, you can.

1. Add a custom column

2.Split [month] column into [Year] column and [Month] column

 

3. Create two measure separately

Measure_sum = 
CALCULATE(
    SUM('Table'[Value]),
    ALLEXCEPT(
        'Table',
        'Table'[Item], 'Table'[Month]
    )
)
Measure_max = 
CALCULATE(
    MAXX(
    'Table',
    [Measure_sum]
    ),
    ALL('Table'[Custom])
)

 

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.