Percentage with slicer
Hello, I am trying to get percentage but if i change the slicer min or max values the percentage doesn't work accurately. Formula I am using is Grid Percentage = COUNTROWS('Grid Info')/CALCULATE(COUNTROWS('Grid Info'), REMOVEFILTERS('Grid Info'[Grid Pass/Fail])) Below on first snapshot you can see it is showing correct percentage but if I change the pops slicer min or max value, it doesn't work properly, as pops are changing too with grid pass/fail. Need to know how I can make it fixed for fail/pass but keeping all other filter values while calculating the percenatge.
