Forum Discussion
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 filters the colum totals - not the OVERALL total. Is there a way to do this?
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())
4 Replies
Right now, it would filter out the 3, 3, and 1 - I am needing it to keep those and instead only filter if the overall TOTAL is <4
Hi meg5w ,
We can add the count to the tooltips and filter the visual based on count making it greater than 3 as the picture. If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
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.
