Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Post Patron
Post Patron

wrong measure result

Hi guys,


I do a measure Asking if  The value in a column is equal to 2 and it only send information for some data not all.


here is my formula


REP FIN = if([reliquat total]=2,1,0)


why is this not working?


here is my link


Super User
Super User


I am not sure whether I correctly understood your datamodel, but could you please try the below?


IF ( ROUND ( [reliquat total], 0 ) = 2, 1, 0 )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

Hello ^^



it does not work


What i need is to allocate one quantity to eache warehouse which have a Rank Less or equal to [Reliquat total]


But it does not work 😞


your solution provide me 1 everywhere i think i uses the Total value of Reliquat total

Hi @SebSchoon1 


According to the description, do you want to compare the value in Rank and the value in Reliquat total? Can you please explain the expected result you want to achieve based on the current sample data?



Best Regards,
Community Support Team _ Jing



Hello sir,


It Works now with



IF([Rank]<>BLANK() && round([reliquat total],0)>=[Rank],1,BLANK())

I think there was an error sooner in my formaulas.


I have noticed something else with this.


It does not compute the column total, it is strange.


Here is the result.


As you can see it works in rows.


Then I do  ==> [Partie entière répartition] + [REP FIN] = [Répartition finale]


But total should be 13 not 9 .




Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors