If statement help

[joshrussin]

Trying to filter out two fields in an if statement as a dimension on a table.

I just want to filter out 'Distribution Orders' and 'Decon - Totes' from the 'Program_Dash' field.

[sunny_talwar]

May be like this in your dimension

If(Match(Program_Dash, 'Distribution Orders', 'Decon - Totes'), Program_Dash)

Or use set analysis in your expression

Sum({<Program_Dash = {'Distribution Orders', 'Decon - Totes'}>}Measure)

[shiveshsingh]

u can try this as your dimension

If(Match(Program_Dash, 'Distribution Orders', 'Decon - Totes'), Program_Dash)