value can not be determined error

[Dunner2020]

Hi there,

I am trying to create measure for the legend for map. I read following statement to calculate the measure.

RANGES = Sheet1[ SWITCH(TRUE(),AND(Sheet1[Confimred Cases]>=0,Sheet1[Confimred Cases]<10),"0 to 9",AND(Sheet1[Confimred Cases]>=10,Sheet1[Confimred Cases]<50),"10 to 49",Sheet1[Confimred Cases]>=50,"50 and more")

However, got the following error:

"The value for 'Confimred Cases' cannot be determined. Either 'Confimred Cases' doesn't exist, or there is no current row for a column named 'Confimred Cases'."

Could anyone help me how to fix the issue?

Here is the snap shot of workspace:

[edhans]

Can you make sure the column name doesn't have a trailing space(s)?

If you are doing a measure, you must specify the table before the column. Just putting [Confirmed Cases] in a measure it is expecting another measure being referenced. That is ok in a Calculated Column though as everything is the current table.

[Dunner2020]

Hi @edhans,

I have removed the sapaces from the column name and also put the table name, but no luck. Here is the updated snippet code:

RANGES = SWITCH(TRUE(),AND(Sheet1[Confirmed_Cases]>=0,Sheet1[Confimred_Cases]<10),"0 to 9",AND(Sheet1[Confimred_Cases]>=10,Sheet1[Confimred_Cases]<50),"10 to 49",Sheet1[Confimred_Cases]>=50,"50 and more")

[v-lid-msft]

Hi @Dunner2020 ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft · Accepted solution]

Hi @Dunner2020 ,

We can try to use the following measure to meet your reqirement:

RANGES =
SWITCH (
    TRUE (),
    AND (
        SUM ( Sheet1[Confirmed_Cases] ) >= 0,
        SUM ( Sheet1[Confimred_Cases] ) < 10
    ), "0 to 9",
    AND (
        SUM ( Sheet1[Confimred_Cases] ) >= 10,
        SUM ( Sheet1[Confimred_Cases] ) < 50
    ), "10 to 49",
    SUM ( Sheet1[Confimred_Cases] ) >= 50, "50 and more"
)

Best regards,