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ė a...
Need Help
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