Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
4 years ago

Incorrect calculation in Power BI

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.

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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