Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 🙂
 

2022-03-30 15_05_59-projet equalif - Power BI Desktop.png

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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])))

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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
Not applicable

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.