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.

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....