Substraction between a fix number and a measure

[Anonymous]

Hello,

I would like to make a substraction between a fix number and a measure :

[New Measure] = 1 - [My Measure].

The result of this New Mesure work fine, but... when i try to filter, this filter doesn't work :

As you see on the screenshot, i have a blank line (on the 1st line).

But if i just insert the measure [My Measure], i don't have this blank line and it work fine.

[My Measure] = 1 - (CALCULATE(divide([nb_retard],[nb_total])))

nb_retard = CALCULATE(count(Qualifs[N°]), Qualifs[EcheanceTheo] < TODAY())

nb_total = CALCULATE(COUNT(Qualifs[N°])

Could you help me ? 

Thanks a lot 🙂

[amitchandak · Accepted solution]

@Anonymous , I tried a measure like this

1- 'Measure'[Margin %]

and it work fine and allow filter to work

or try like
(CALCULATE(divide([nb_total]- [nb_retard],[nb_total])))

[Anonymous]

It work fine with the second solution, thanks a lot !! 🙂