Can we create a column which calculates distinct of 2 same columns but with different filter?
Consider Column_1 is having a filter Filter_1 and Column_2 is having a filter Filter_2, here both the columns are same but filters are different. Also filters are coming from Presentation Variables.
I've tried to create one but distinct function requires second parameter as Group By.
Solved! Go to Solution.
Alternate: In an insight drag the column to the measures area - twice. Open the measure property and drag a formula to the "filter" target:
It's a nice feature. Note: I think you'll find it's only available for aggregated measures. If it needs to be repeatable ( e.g. "Sales for California" ) make it a formula column in the schema. You'll wind up w/ a bunch of formula columns, but runtime performance will be better.