Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
4 years ago

Not equal column value in Power BI

Hello,

 

I have issue, I tried to check if column name equal Taip then sum1, else sum2. But never Taip is reached even Taip is in column.

So why it happens?

Here is a visual:

 

Meas = if(SELECTEDVALUE(_op_kiekis[Objektinė apskaita])="Taip",1,0)
Need Help

2 Replies

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    Check that in the data there are no trailing spaces or control characters

    • Analitika's avatar
      Analitika
      Post Prodigy
      4 years ago

      It contains 1 but still wrong with a measure. My measure all time reach one measure.

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