Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

How to count

I have i pbix file https://easyupload.io/9vy2gb

 

 

How to make working Meausures with such logic

AfterDisc =
VAR App = sum(Table4[SUM_CRE])
VAR Percent0 = MAX(Table3[p0])
VAR Percent1 = MAX(Table3[p1])
VAR Percent2 = MAX(Table3[p2])
VAR Exc0 =
SWITCH(
TRUE(),
Max(Klients[klient]) = "JSC4" && MAx('Date'[sort_month]) >= "2019-11", 0,
DIVIDE(Percent0,100)
)
VAR Exc1 =
SWITCH(
TRUE(),
Max(Klients[klient]) = "JSC4" && MAx('Date'[sort_month]) >= "2019-11", 0,
DIVIDE(Percent1,100)
)
VAR Exc2 =
SWITCH(
TRUE(),
Max(Klients[klient]) = "JSC4" && MAx('Date'[sort_month]) >= "2019-11", 0,
DIVIDE(Percent2,100)
)
VAR PO = App - (APP*Exc0)- (APP*Exc1)- (APP*Exc2)

RETURN

SWITCH(
True(),
DATESBETWEEN('Date'[Date],"2017-01","2017-12"), App,
COUNT(Table4[SUM_CRE])<= 0, App,
Max(Klients[klient]) = "JSC2" , App,
Max(Klients[klient]) = "JSC3" , App,
PO
)
------------------------------------
Total_Discounts =
VAR App = [AfterDisc]
VAR Disc = SUM(Table2[Suma])
VAR AllDisc = Sum(Table1[suma])
VAR SUm_creByKlient = [SUm_creByKlient]
VAR P = SUm_creByKlient * AllDisc

RETURN

SWITCH(
TRUE(),
Max(Klients[klient]) = "JSC5" && Max(Goods[Code]) IN {"1","2","3"}, App,
App - DIVIDE(App,P) - Disc

)
 
Expected result for code 47746010

AfterDisc = 643.20
Total_Discounts = 433.09
Need Help
Show and Tell
Tips and Tricks

2 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    5 years ago

    Hi Analitika 

     

    I've worked out the problem in your capture, I attached the pbix here

    but for the measure, plz elaborate more

    Max(Klients[klient]) = "JSC4" && MAx('Date'[sort_month]) >= "2019-11"

    would you like to set the Klients as slicer? so the logic should be when slicer is "JSC4",and date slicer >= 2019-11, then exc0 = 0?

    also for this part:

    SWITCH(
    True(),
    DATESBETWEEN('Date'[Date],"2017-01","2017-12"), App,
    COUNT(Table4[SUM_CRE])<= 0, App,
    Max(Klients[klient]) = "JSC2" , App,
    Max(Klients[klient]) = "JSC3" , App,
    PO
    )
    Plz confirm the how's work for Klient column.
     
    • Analitika's avatar
      Analitika
      Post Prodigy
      5 years ago

      Ty, but file is wrong

       

      I need make work thoose parts, klients cant be in slicer, only in measures!!!

       

      Max(Klients[klient]) = "JSC4" && MAx('Date'[sort_month]) >= "2019-11"

      DATESBETWEEN('Date'[Date],"2017-01","2017-12"), App,