Hi,
I have created a Master Item in Set analysis to calculate an array with count of Calls divided with a measure that is calculating a subtraction among columns from a table. Below you may find the calculations:
Aggr( count( {<[Call Method]={'Face to Face','Video'},Category={'Calls'}>} [Call Name]),Year_Month)/([Calculation1])
where
Calculation1=(Sum({<Year_Month= >} Aggr( AVG_WD, Year_Month,[Created By]))-sum({<[Call Method]={'TOT'}>} Value1)-sum({<[Call Method]={'TOT'}>} Value1Value2))
The problem is that I would like to use this in a Sheet that has a filter on Year_Month but I don't want the visual that shows this measure to be affected by the Year_Month selection (always display all months). I have tried adding the condition in multiple ways but it has always been filtered.
Could someone assist on correct syntax and use of the no filter condition with Arrays?
Thanks in advance