topic Substraction between a fix number and a measure in DAX Commands and Tips

Substraction between a fix number and a measure

Anonymous — Wed, 30 Mar 2022 13:12:52 GMT

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 — Wed, 30 Mar 2022 13:22:14 GMT

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 — Wed, 30 Mar 2022 13:47:33 GMT

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