Create a MAX MEASURE which works in a timeline chart

[CaptainHenkka]

I am sure there are tons of ways to do this, but since none of the ones I found here worked, I will share my findings.

Problem: I needed to show the MAX value as a separate line in a time-based Line/Bar combochart AND have the MAXimum value respect the selected time range.

Solution:

Create a new MEASURE, which reads like this:

twsMax = 
MAXX(
	ALLSELECTED(weather),
	CALCULATE(MAX('weather'[tws]))
)

And if I am not mistaken, this measure will get all the SELECTED rows in my table called "weather" and returrn the MAX value for the column called "tws".

[v-danhe-msft]

Hi @CaptainHenkka,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @CaptainHenkka,

Based on my test, you could refer to below steps:

Sample data

Create a measure

Measure = MAXX(ALLSELECTED(Table1),'Table1'[Value])

Result:

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/m25gehye19maulo/Create%20a%20MAX%20MEASURE%20which%20works%20in%20a%20time...

Regards,

Daniel He

[CaptainHenkka]

Thank you @v-danhe-msft, yes this also works and is admittedly a simpler way 🙂 Thanks for the tip!