Forum Discussion

t-irp's avatar
t-irp
New Member
3 years ago
Solved

Another DAXComparison Operations Do Not Support Comparing Values Of Type Integer With Type Text

Hello, I did a search and found a similar post but despite my efforts to solve my own issue, I am blocked and could use some guidance. I did follow the steps in that other post, which were quite c...
DAX
  • t-irp's avatar
    t-irp
    3 years ago

    I made a lot more progress. It seems that the value 1000 is a string, not a number.

    This

    ReportValue (DAX) = Switch(TRUE(), FORMAT(GL_BALANCE_MC[Cost_Center],"Standard") = FORMAT(1000,"Standard"), "Cash")

    gets me past the error. Hopefully it helps someone

  • t-irp's avatar
    t-irp
    3 years ago

    Sorry for the late reply, = the issue was that "1000" needed to be a string for whatever reason.

t-irp's avatar
t-irp
New Member
3 years ago

They are numbers such as 1000, 1200, 1351, etc, but some are empty/null

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi t-irp 

not sure about your use case. try like:

ReportValue (DAX) =

Switch( TRUE(),NOT(ISBLANK(VALUE(GL_BALANCE_MC[Cost_Center]))) , "Cash")

 

or why you want to compare with 1000?

  • t-irp's avatar
    t-irp
    New Member
    3 years ago

    Hi

    Longer term, I need to create a report that shows this, but for 54 rows.

    ......

    Inventory13001399

    Some number

    Prepaids14001439Some number
    Other Current Assets14401499Some number
    Total Current Assets10001499Some number

    .......

    Note that "Total Current Assets" includes a collection of GL_codes that were already chosen ealier for other groupings. In my mind, I think I should have something like;

     

    ReportValue (DAX) = Switch(TRUE(), NOT(ISBLANK(VALUE(GL_BALANCE_MC[Cost_Center]))) >= 1000 &&  NOT(ISBLANK(VALUE(GL_BALANCE_MC[Cost_Center]))) <= 1499  , "Total Current Access")
     
    But 54 of these in total, one for each line item aggregating the appropriate GL_Codes.
    Cash
    AR - Trade
    AR - Other
    Costs in Excess of Billings
    Intercompany Assets

    50 more....