Forum Discussion

Dunner2020's avatar
Dunner2020
Post Prodigy
6 years ago
Solved

value can not be determined error

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[Co...
Need Help
Show and Tell
Tips and Tricks
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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,

     

Dunner2020's avatar
Dunner2020
Post Prodigy
6 years ago

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's avatar
v-lid-msft
Community Support
6 years ago

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,