Forum Discussion
Graph filter for OVERALL total
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())
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.
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())