Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Comparing values of type text to integer

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

 

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

7 REPLIES 7
PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Anonymous
Not applicable

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

@Anonymous 

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

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


PhilipTreacy
Super User
Super User

@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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Anonymous
Not applicable

@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
Super User
Super User

@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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Anonymous
Not applicable

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.