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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.