Line chart- Create Maximum line

[lomi89]

Hello,

I would like to know if it possible to create a Maximum line when there are two dimensions as picture:

The line should be dynamic depends on the filters.

Thank you very much.

[Taoufiq_Zarra · Accepted solution]

@lomi89 if i understood correctly

in reference line

in reference line you can use the max() expression like :

 like this example :

[lomi89]

Hello,

The measure is sum(costs) and there two dimensions (line and group). When I don't want to filter, the max line is not correctly and depends on the filters, also, it is not perfect.

Are there any solution?

Thank you.