Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
Nope, its already in numerical format.
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |