Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
u can try this as your dimension
If(Match(Program_Dash, 'Distribution Orders', 'Decon - Totes'), Program_Dash)