Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I currently have a double match expression but when I click on a dimension in a table it applies a filter. I don't want the filter to be applied. Will doing set analysis help in this situation? How can I transform it?
=if(match(Type,'Car') and match(Period,'Months'), Other)
What exactly are you trying to achieve with this formula? Which dimension selection are you trying to ignore? This appears to be equivalent to If(Type='Car' and Period='Months',Other) but that won't behave any differently from the Match statement.