Easy bi for measurement

[karim -Atlassway-]

Hello team 

Im using easy BI , im new , but i find some difficulty in writing measurement condition (IIF).

My code is 

[Measures].[ prévisionnel restant]

CASE
WHEN [Measures].[Montant engagé (TTC) created] > [Measures].[Montant prévisionnel (TTC) created] THEN 0
WHEN [Measures].[Montant du règlement (TTC) created] > [Measures].[Montant prévisionnel (TTC) created] THEN 0
ELSE [Measures].[Montant prévisionnel (TTC) created] - [Measures].[Montant engagé (TTC) created] - [Measures].[Montant du règlement (TTC) created] 
END

But it takes only the third case althought if case one are right.

In case 3 fact 24 : (Montant prévisi )32000..... < 40000 ( montant engagé ) it's right but they dont take it in concideration

I like to get this result 14500 not 5500.

Please find below all details 

regards

Karim

[Fabian Lim]

Hi @karim -Atlassway-

You need to review your formula.  There could be conflicting statements.

Try something like this:

CASE
WHEN ([Measures].[Montant engagé (TTC) created] > [Measures].[Montant prévisionnel (TTC) created] OR [Measures].[Montant du règlement (TTC) created] > [Measures].[Montant prévisionnel (TTC) created])

THEN 0

ELSE [Measures].[Montant prévisionnel (TTC) created] - [Measures].[Montant engagé (TTC) created] - [Measures].[Montant du règlement (TTC) created] 

END

Regards,

Fabian