Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

 

 

  • 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

7 Replies

  • 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's avatar
      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

      • PhilipTreacy's avatar
        PhilipTreacy
        Icon for Super User rankSuper User

        Anonymous 

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

        Regards

        Phil

  • 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 

    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