Always used same measure despite filtering in measure Power BI

[Analitika]

Hello,

I would like to ask how fix my issue. I am using formula:

bendra_suma_ar_objektine8 = 
 if(SELECTEDVALUE(_op_kiekis[Objektinė apskaita]) in {"Taip",""}, [Bendra kaina_new],
      [Bendra kaina_new_be_obj]
      
)

but it returns calculation based on Bendra kaina_new_be_obj. 

In last column is value "Taip". So according to this it should use Bendra_kaina_new_be_obj.

So how to fix this?

[Anonymous]

@Analitika , I believe the measure should be written like this:

bendra_suma_ar_objektine8 = 
    SUMX(
        VALUES('TableName'[Tipas],
        if(SELECTEDVALUE(_op_kiekis[Objektinė apskaita]) in {"Taip",""}, [Bendra kaina_new],
        [Bendra kaina_new_be_obj])
    )

You will need to replace 'TableName' with the name of the table that contains the [Tapis] column used on the table visual.

[Analitika]

No it didn't change. Same result.

[Analitika]

Tipas is from Ikainiai table not op_kiekis. Both tables have relationship.

[Anonymous]

@Analitika try this:

bendra_suma_ar_objektine8 = 
    SUMX(
        VALUES('Ikainiai'[Tipas]),
        if(SELECTEDVALUE(_op_kiekis[Objektinė apskaita]) in {"Taip",""},
            [Bendra kaina_new],
            [Bendra kaina_new_be_obj]
        )
    )

[Analitika]

Wrong. Need not sum but use one of both measures depending if objektine apskaita equals Taip.

If op_kiekis objektine_apskaita equals Taip. then measure 

[Bendra kaina_new] else 

[Bendra kaina_new_be_obj]

[Anonymous]

I think this version should do it:

bendra_suma_ar_objektine8 = 
    SUMX(
        VALUES(_op_kiekis[Objektinė apskaita],
        if(SELECTEDVALUE(_op_kiekis[Objektinė apskaita]) in {"Taip",""}, [Bendra kaina_new],
        [Bendra kaina_new_be_obj])
    )

[Analitika]

I said I no need to sumx, sum is already done by bendra kaina

[Anonymous]

@Analitika , could you please try the measure I suggested and post the results?

[Analitika]

Here result last column. So it is wrong result should be as in second column.

[Anonymous]

@Analitika Could you explain more clearly, please? I don't understand what results you are trying to achieve.

[Analitika]

My problem is to calculate according to condition, if objektine apskait ="Taip"

bendra_suma_ar_objektine5 = 
  SWITCH (
      TRUE (),
      MAX(_op_kiekis[taip_ne])=1,[Bendra kaina_new],
       [Bendra kaina_new_be_obj]
      
)

So according to condition it should take measure bendra_kaina_new or 

[Bendra kaina_new_be_obj]. But now seems that rows are wrong. 

I marked rows total is same as last column. But rows values don't match values in first column values. That;s weird total is same but rows are different.