Static measure line in chart

[dries_clairhout]

Good day to all.

I have a question, I think it will be simple, 

but i can be mistaken.

I Have a combograph where results are displayed per month.

dimension: Month

Measure: sum(amount)

The Line measure is = sum(if(soort = 'OMZET', Amount))

Now this Line measure should become static no matter what the selection is.

So if the customer selects a certain account, the bars adjust to this selection, but the total of the line measure stays the same.

So if the customer select all accounts with number 62, the bars adjust, but the line stays the same.

So that the customer can see the relation between this.

If any questions,

I will be happy to answer.

Thanks in advance

Dries

[tresesco]

Try the line expression like:

sum( {1<soort = {'OMZET'}>} Amount)

[dries_clairhout]

Hello,

Thank you for the respons,

but this gives me a very over the top result.

Any ideas?

[tresesco]

Could you explain the issue a bit more?

[dries_clairhout]

I think I know whats going on,

so it's all the years combined.

So I would need a measure that only looks at the year dimension, but ignores the rest,

is this even possible?

Right now the line always shows all years combined.

[tresesco · Accepted solution]

For specific (I am using 2019 in example) year data, try like:

sum( {1<soort = {'OMZET'}, Year={'2019'}>} Amount)

[dries_clairhout]

Thank you,

this gets me close,

but still more than it should be,

but that's probably something in my data model!

I thank you good sir.