Switch true can not convert text with integer

[rsanyoto]

Hi guys,

I have the following measure:

MeasureXXX =

SWITCH( TRUE(),

VALUES(DimDate[year])= "2019", [Total Employee 2019],

VALUES(DimDate[year])= "2020", [Totaal Employee2020],

BLANK())

Unfortunatly i received the following error message:

the column year has the data type whole number and the two measures of total employee 2019 and total employee 2020 are created as follows:

total employee 2019= CALCULATE(DISTINCTCOUNT('Bezetting'[Personeelsnummer]),

FILTER(Bezetting,Bezetting[month]=DATE(2019,12,1)))

total employee 2020 = CALCULATE(DISTINCTCOUNT('Bezetting'[Personeelsnummer]),

FILTER(Bezetting,Bezetting[month]= MAX('Bezetting'[month])))

Any suggestions? many thanks

[amitchandak · Accepted solution]

@rsanyoto , check datatype of year once

Try like

MeasureXXX =
SWITCH( TRUE(),
VALUES(DimDate[year])= 2019, [Total Employee 2019],
VALUES(DimDate[year])= 2020, [Totaal Employee2020],
BLANK())

or

 
MeasureXXX =
SWITCH( TRUE(),
max(DimDate[year])= 2019, [Total Employee 2019],
Max(DimDate[year])= 2020, [Totaal Employee2020],
BLANK())

[rsanyoto]

thanks @amitchandak  the second measure is the solution!!!