Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
5 years ago
Solved

Cell Validation

Dear All   I want to create a measure to find if any cell value is having more than 1 character (A-Z), then it should return that as an error.   Digits are also not accepted as a value and should...
Need Help
Show and Tell
  • MFelix's avatar
    MFelix
    5 years ago

    Hi gauravnarchal ,

     

    Try the following measure:

     

    Measure = 
SWITCH (
    TRUE ();
    ISERROR ( MOD ( SELECTEDVALUE ( 'Table'[Indicator] ); 2 ) ) = FALSE; "ERROR";
    LEN ( SELECTEDVALUE ( 'Table'[Indicator] ) ) > 1; "ERROR";
    "OK"
)

     

     

  • MFelix's avatar
    MFelix
    5 years ago

    Hi gauravnarchal ,

     

    Try the following code:

    Measure = 
SWITCH (
    TRUE ();
    ISERROR ( MOD ( SELECTEDVALUE ( 'Table'[Indicator] ); 2 ) ) = FALSE; "ERROR";
    SELECTEDVALUE ( 'Table'[Indicator] ) = BLANK(); "ERROR";
    LEN ( SELECTEDVALUE ( 'Table'[Indicator] ) ) > 1; "ERROR";
    "OK"
)