Incorrect calculation in Power BI

[Analitika]

Hello,

I would like to ask how to calculate if column contains Taip. I used this formula:

bendra_suma_ar_objektine7 = 
  SWITCH (
      TRUE (),
      MAX('_op_kiekis'[ZU0_KOD])="Objektinė apskaita" &&  MAX('_op_kiekis'[Objektinė apskaita])="Taip",[Bendra kaina_new],
      [Bendra kaina_new_be_obj]
      
)

but despite the value in objektine apskaita, all time bendra kaina_new_be_obj is being used. So how to fix it?

I marked matched but is not ok, it should calculated  like in first column. In this last column total must match first or third column total.

[Anonymous]

Hi @Analitika ,

According to the data inside the screenshot you provided, the calculation is correct.  There is only one record (the part circled in red) that meets the condition (MAX('_op_kiekis'[ZU0_KOD])="Objektinė apskaita" && MAX('_op_kiekis'[Objektinė apskaita])="Taip"). Then take the value of the measure [Bendra kaina_new], which is 0. Other records that do not meet the condition take the value of the mesure [Bendra kaina_new_be_obj] respectively.

Best Regards