HELP in SUM

[raceberos]

Good day to all

i got this data,

what i want to do is if i filter the Reference to 2 and the

sum of amount must be 300 coz of reference 1+2 = Amount 100+200

i use this formula  " Sum({<Reference={"<=$(=Max(Reference))"}>}[Amount]) "

i got it right if i select in the filter 1 and 2 but it doest work if i select in the filter only the 2

Reference	Amount
1	100
2	200
3	300
4	400

does anyone have an idea how to compute it

thanks...

[tresesco]

Try like:

Sum({<Reference, HSL={"$(=Max(Reference))"}>}[Amount])

[raceberos]

Hi there mate thanks for the help but it doesn't work as expected you coz if i filter the referece it always give me 1000 as sum of amount...

Thanks

[tresesco]

Do you need to check it in the chart or in KPI object? And I don't see a field called HSL ?

[tresesco]

I guess if it is the same field Reference, you could try:

Sum({<Reference={"<=$(=Max(Reference))"}>}[Amount])

[raceberos]

oww sorry for that i posted the wrong formula

"Sum({<Reference={"$(<=Max(Reference))"}>}[Amount])"  please

replace the HSL to Reference.

thanks for that.

[tresesco]

Try the expression I showed above. Positioning of '<=' needs to be corrected.