Forum Discussion
Visual Filter : Applied to Sum , instead of values
Hello All,
I have created a matrix where values are displayed. Columns contain weeks and Rows contain company names.
So an element of this matrix would correspond to a week and a company name.
I wish to filter these elements, so for each week the value is above a threshold, for example 50.
I have attached a sample , even after applying the visual filter, the matrix displays information of company B as its summation is above 50. I wish to apply the filter in such a way that it is applied to element values and not summations.
How can I fix this ?
2 Replies
- amitchandak
Super User
abdul26 , create a measure like this and use it in visual level filter
calculate([yourmeasure], removefilters(Table[week]))
I tried what you suggested. But, it didn't work.
I am using Weeks as columns in the matrix, so unfiltering and creating a measure would not have any effect, it seems.
