Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Reduce data by adding new column

I'm trying to reduce the amount of data to meet the following requirement

 

Can’t have one dimension greater than 23 inches, or 2 dimensions greater than 14 inches, or 3 dimensions greater than 11 inches.

 

Does anyone know how to make an expression to tell me true or false if it meet this requirement?

 

I would Also if it's easier to just say my length width and height are not larger than 11 would be even helpful

  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Your check is for a singel value > 58.42 which your hightlighted row is not.

11 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

    Anonymous 

    I think this is along the lines of what you are looking for.  It is a calculated column on the table.

    Check = 
SWITCH (
    TRUE(),
    'Table'[Length] > 23 || 'Table'[Width] > 23 || 'Table'[Height] > 23, "One over 23",
    ('Table'[Length] > 14 && 'Table'[Width] > 14) || ('Table'[Width] > 14 && 'Table'[Height] > 14) || ('Table'[Height] > 14 && 'Table'[Length] > 14), "Two over 14",
    'Table'[Length] > 11 && 'Table'[Width] > 11 && 'Table'[Height] > 11, "Three over 11",
    "good"
)

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I must be doing something wrong as I get errors in mine

       

      I copy and pasted the following: 

       

      Check =
      SWITCH (
      TRUE(),
      'Table'[UOM_LENGTH] > 23 || 'Table'[UOM_WIDTH] > 23 || 'Table'[UOM_HEIGHT] > 23, "One over 23",
      ('Table'[UOM_LENGTH] > 14 && 'Table'[UOM_WIDTH] > 14) || ('Table'[UOM_WIDTH] > 14 && 'Table'[UOM_HEIGHT] > 14) || ('Table'[UOM_HEIGHT] > 14 && 'Table'[UOM_LENGTH] > 14), "Two over 14",
      'Table'[UOM_LENGTH] > 11 && 'Table'[UOM_WIDTH] > 11 && 'Table'[UOM_HEIGHT] > 11, "Three over 11",
      "good"
      )

       

      Can you add a screen shot of you custom column dialogue box?

      • jdbuchanan71's avatar
        jdbuchanan71
        Super User
        6 years ago

        Is your table named 'Table'?  If not then you have to change my measure to match the name of the table in your model.

        Or you can take the table reference out of the formula:

        Check = 
SWITCH (
    TRUE(),
    [UOM_LENGTH] > 23 || [UOM_WIDTH] > 23 || [UOM_HEIGHT] > 23, "One over 23",
    ([UOM_LENGTH] > 14 && [UOM_WIDTH] > 14) || ([UOM_WIDTH] > 14 && [UOM_HEIGHT] > 14) || ([UOM_HEIGHT] > 14 && [UOM_LENGTH] > 14), "Two over 14",
    [UOM_LENGTH] > 11 && [UOM_WIDTH] > 11 && [UOM_HEIGHT] > 11, "Three over 11",
    "good"
)