Forum Discussion
Solved
Graph filter for OVERALL total
I am needing to filter a graph, basically saying if the total count is <4, don't show the graph. I tried adding this to the visual level filters but did not have any luck, as it breaks it down and fi...
Hi meg5w ,
To create a measure as below and make the visual filtered by it as the picture.
Measure 2 = var a = CALCULATE(SUM(Table1[count]),ALLSELECTED(Table1)) return if(a>4,1,BLANK())
Thank you but what I am running into is when I do that, it will not take the TOTAL count - it will just take the count of the individual columns. Example:
No filterCount > 4 filter applied to same data
I would want it to still show those 3 and 1 columns because the TOTAL count (3+3+9+7+1) is >4. There will be instances when that total count is < 4 and that is what I would not want to show.
v-frfei-msft
Community Support
Community SupportHi meg5w ,
To create a measure as below and make the visual filtered by it as the picture.
Measure 2 = var a = CALCULATE(SUM(Table1[count]),ALLSELECTED(Table1)) return if(a>4,1,BLANK())