Getting error when trying to use one of the measure in the visual

[Sid_125]

Hi,

I am trying to use a measure which I created in one of the visual but I am getting an error:

POWER BI ERROR: calculation error in measure: DAX comparison operations do not support comparing values of type integer with values of type text. Consider using the VALUE or FROMAT function to convert one of the values.

This is my DAX expression for that measure: 

06.1 CY TRIR for abc = CALCULATE(DIVIDE([01 Reportable Incidents], DIVIDE(SUM('MinesProdYearly_dataset'[ANNUAL_HRS]),200000)), Mines[MINE_ID] = "3605018", USERELATIONSHIP(dimDate[Year],MinesProdYearly_dataset[CALENDAR_YR]))

All of the columns mentioned above has Integer data type and still it is asking me to convert one of the values. I got really confused here! Can someone please help me?

Thanks,
Sid

[Sid_125]

Nope, its already in numerical format.

[nvprasad]

Hi Sid_125,

One of the column you used in the measure is in text format. I guess it could be '[ANNUAL_HRS] column.

Please check and change to numarical format.

Appreciate a Kudos! ‌‌
If this helps and resolves the issue, please mark it as a Solution! ‌‌

Regards,
N V Durga Prasad