wrong measure result

[SebSchoon1]

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

https://we.tl/t-fHRehqwIvv

[Jihwan_Kim]

Hi,

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

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

[SebSchoon1]

Hello ^^

@Jihwan_Kim 

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

[v-jingzhang]

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

[SebSchoon1]

@v-jingzhang 

Hello sir,

It Works now with

REP FIN = 

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 .