Comparing values of type text to integer

[Anonymous]

Hi,

Although I have heard of this error "You cannot compare values of type text to integer" a lot of times before, Im still not able to figure out what conversion I need to make with my below calculation. Please help

Calculated Column =
VAR id1 = [Feature ID]
RETURN
    IF (
        [Executed Flag] = 1,
        IF (
            CALCULATE (
                COUNTROWS ( 'Table' ),
                'Table'[Feature ID] = id1,
                'Table'[202/3 Flag] = 1
            ) = 2,
            IF (
                CALCULATE (
                    COUNTROWS ( 'Table' ),
                    'Table'[Feature ID] = id1,
                    'Table'[User Story Status] = "Complete or Closed"
                ) = 2,
                "Workshop Complete",
                "Workshop Executed but not Completed"
            ),
            "Workshop Executed but not Completed"
        ),
        "Not Executed"
    )

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Your [202/3 Flag]column was Text and it needed to be Whole Number type.

I've changed it and now your Calculated Column code works.

Download the PBIX

Regards

Phil

[Anonymous]

Thank you so much @PhilipTreacy Im slowly getting a jist of typecasting functionality in DAX now.

Can you please also help me the logic of the question on the other link. Tagged you there

[PhilipTreacy]

@Anonymous 

Yes I find it frustrating that columsn that obviously contain numbers are still imported as text.

Regards

Phil

[PhilipTreacy]

@Anonymous 

It's not ideal to look at copied data like that, you can't tell if numbers are stored as text or numbers.  Much better to supply the PBIX file.

But, is your Executed Flag column Text data type? It should be Whole Number.

And there's no column called [202/3 Flag] in the data on that page you linked to. It should also be a numeric data type like Whole Number. Is it Text?

Regards

Phil

[Anonymous]

@PhilipTreacy sorry for the confusion

Here is the link to the file

https://drive.google.com/file/d/1dY6mjEAKGdhi_9vI-jxSulwxGSQLVL9J/view?usp=sharing

If you can also help me resolve the other question(link given) i'll be obliged

[PhilipTreacy]

@Anonymous 

It's hard to say without seeing your data.

Somewhere in that code you're comparing a text value with a number.

Regards

Phil

[Anonymous]

Here is the data. This question is linked with this
https://community.powerbi.com/t5/Desktop/For-Each-and-Exists-clause-implementation-in-DAX/m-p/165433...

You can refer this as well