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])
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?