Substraction between a fix number and a measure
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 🙂
