Filter on a negative value

[MrLynge]

Hi

I am trying to make the following calculation with a filter:

=CALCULATE(MAX('Fakturaer'[No_]);FILTER('Fakturaer';'Fakturaer'[Service Item Beriget]=Artikler[No_] && Fakturaer[# fak minus # kre]=-1))


The problem is with the bolded part. Here I want to filter on a negative value, but the calculate function keeps returning blanks, as if it does not understand the -1 value.

I know that I can solve the problem by converting the negative values, but since I can think of a lot of cases were referring to a negative value could be helpful, I hope that some of you have a solution?

 

[Yongle]

maybe (untested)
Fakturaer[# fak minus # kre]="-1"

 

[MrLynge]

maybe (untested)
Fakturaer[# fak minus # kre]="-1"

____


Hi Yongle,

Thanks for reply - a good idea, but unfortunately did not work