Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Icon for Helper V rankHelper V
5 years ago
Solved

Error "comparing values integer with text"

Hi,   I'm getting the error "DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the v...
Need Help
  • CarlsBerg999's avatar
    CarlsBerg999
    5 years ago

    Hi,

     

    The issue was somehow connceted to the the [Sales Total]. The measure was producing a result, but it had an underlying LOOKUPVALUES -reference that was broken. Quite honestly it seems like a bug to have the measure working in one place but not at another. Never the less, solved. 

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
5 years ago

Try moving the ALLEXCEPT statment out to the RANKX statement:

RANKX (
ALLEXCEPT ('Table3', 'Table3'[Customer ID] )
CALCULATE (
[Sales Total],
DateTable[Year] = YEAR ( TODAY () ),
'Table1'[Task Status] <> "Stopped",
'Table2[Status] <> "Cancelled"
),
,
DESC
)
CarlsBerg999's avatar
CarlsBerg999
Icon for Helper V rankHelper V
5 years ago

Hi,

 

The issue was somehow connceted to the the [Sales Total]. The measure was producing a result, but it had an underlying LOOKUPVALUES -reference that was broken. Quite honestly it seems like a bug to have the measure working in one place but not at another. Never the less, solved.