Formula problem

Question

Hello,I'm writing to you because I have a major formula problem.In my formula, which you'll see below, I'm trying to recalculate a route order&nbsp; (N° Ordre de ligne) for customers who are "Sur appel".Therefore, customers after this type of customer are assigned a -1 on their scheduling order.Customers before this event are not affected. However, my formula applies this subtraction to all customers, and I can't find a solution. If someone could help me, please.2.9 OrdrePlanifie =VAR OrdrePlanifieActuel = SELECTEDVALUE(FAIT_CLEAR_UO_Planif[No Ordre ligne])VAR FrequenceActuelle = SELECTEDVALUE(FAIT_CLEAR_UO_Planif[Fréquence theorique])VAR StatutPresence = [1.0 Contrôle présence client]-- Sur appel si fréquence videVAR FrequenceVideActuelle =&nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; FrequenceActuelle = BLANK(),&nbsp; &nbsp; &nbsp; &nbsp; "Sur appel",&nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE(FAIT_CLEAR_UO_Planif[No Ordre ligne])&nbsp; &nbsp; )-- Rechercher un dossier sur appel précédentVAR DossierSurAppel =&nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; MAX(FAIT_CLEAR_UO_Planif[No Ordre ligne]),&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALL(FAIT_CLEAR_UO_Planif),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mesures[1.0 VérificationSurAppel] = "Sur appel"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; FAIT_CLEAR_UO_Planif[No Ordre ligne] &lt; OrdrePlanifieActuel&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )RETURNSWITCH(&nbsp; &nbsp; TRUE(),&nbsp; &nbsp; -- Cas BI en plus sans ordre planifié&nbsp; &nbsp; StatutPresence = "BI en plus" &amp;&amp; ISBLANK(OrdrePlanifieActuel), "BI en plus",&nbsp; &nbsp; -- Cas BI en moins&nbsp; &nbsp; StatutPresence = "BI en moins", OrdrePlanifieActuel,&nbsp; &nbsp; -- Cas sur appel&nbsp; &nbsp; FrequenceVideActuelle = "Sur appel", "Sur appel",&nbsp; &nbsp; -- Cas BI en plus avec ordre planifié&nbsp; &nbsp; StatutPresence = "BI en plus" &amp;&amp; NOT ISBLANK(DossierSurAppel)&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; OrdrePlanifieActuel &gt; DossierSurAppel, OrdrePlanifieActuel - 1,&nbsp; &nbsp; -- Cas classique avec un précédent sur appel : appliquer -1 uniquement si après&nbsp; &nbsp; NOT ISBLANK(DossierSurAppel)&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; OrdrePlanifieActuel &gt; DossierSurAppel, OrdrePlanifieActuel - 1,&nbsp; &nbsp; -- Cas par défaut&nbsp; &nbsp; OrdrePlanifieActuel)There are a lot of terms in French, so if you need clarification or additional information, don't hesitate to ask!Thank you again for your time.

lbendlin · Accepted Answer

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Forum Discussion

Formula problem

1 Reply

Related content

Measure formula problem

If formula

formula

DAX Formula Help

Problem with Formula