Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])))
Solved! Go to 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 , 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])))
It work fine with the second solution, thanks a lot !! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |