cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Analitika
Post Prodigy
Post Prodigy

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:

Analitika_0-1655462304088.png

 

Meas = if(SELECTEDVALUE(_op_kiekis[Objektinė apskaita])="Taip",1,0)
2 REPLIES 2
johnt75
Super User
Super User

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

Analitika_0-1655464040601.png

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])
    )

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors