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 ...
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

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

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"
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
     

    I changed the name but I still get an error, see my screenshot

     

    • jdbuchanan71's avatar
      jdbuchanan71
      Super User
      6 years ago

      You need to take the 

      'Check ='

      out of your fomula.  That is what is causing it to not work.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I removed that and still error, not sure what is causing the error everything else should be swapped correct with my names