Forum Discussion
setis
Post Partisan
Post PartisanDAX comparison operations do not support comparing values of type integrer with type text
Hi all,
Easy question I hope.
I am getting the above error with the following measure.
CountCases LY is Format: Whole number
'Calendar'[Year] is Format & Data type: Whole Number
2019 Forecast(CaseCount) =
CALCULATE (Cases[CountCases LY];
FILTER('Calendar';VALUE('Calendar'[Year]="2019")))I've tried this one as well witht he same result. Any idea what it could be? Thanks!!
2019 Forecast(CaseCount) =
CALCULATE (Cases[CountCases LY];
FILTER('Calendar';'Calendar'[Year]="2019"))setis Try this..
2019 Forecast(CaseCount) = CALCULATE (Cases[CountCases LY]; FILTER('Calendar';VALUE('Calendar'[Year])=2019))
4 Replies
- PattemManohar
Community Champion
setis You are not closing the VALUE function parenthesis where it supposed to.
Please try this..
2019 Forecast(CaseCount) = CALCULATE (Cases[CountCases LY]; FILTER('Calendar';VALUE('Calendar'[Year])="2019"))
setis- PattemManohar
setis Try this..
2019 Forecast(CaseCount) = CALCULATE (Cases[CountCases LY]; FILTER('Calendar';VALUE('Calendar'[Year])=2019))