topic Percentage with slicer in DAX Commands and Tips

Percentage with slicer

Anonymous — Wed, 05 Apr 2023 22:18:58 GMT

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.

Re: Percentage with slicer

Anonymous — Thu, 06 Apr 2023 15:54:39 GMT

Any help on this please?

Re: Percentage with slicer

Anonymous — Fri, 07 Apr 2023 02:12:54 GMT

Hi Anonymous

You can use "Edit interaction" to set pop slicers not affected by "Grid slicer".

Click the "Grid slicer" then select "Edit interactions"

Then choose the pop slicers and select "None" icon, the slicers will not affected by the Grid slicer.

You can refer to the following link.

Change how visuals interact in a report - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Percentage with slicer

Anonymous — Fri, 07 Apr 2023 16:37:51 GMT

I am using that to display the percentage on the card, I can't select none for that. and I actally don't want to have the slicer filter get disconnected with the rest. I want the count to be what it was before the grid pass/fail selected filter but when I try to use remove filter formula on measure it will still count the rows of that filterd pops. Kindly let me know what can I do.

Re: Percentage with slicer

Anonymous — Mon, 10 Apr 2023 01:01:11 GMT

Hi Anonymous

You can try the following code,

Grid Percentage = COUNTROWS('Grid Info')/COUNTROWS(ALLEXCEPT('Grid Info'[Total Pops]))

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Percentage with slicer

Anonymous — Mon, 10 Apr 2023 15:36:09 GMT

that will ignore all the Pops, what I want is the Pops before we selected grid pass/fail to be counted in the calculation for that specfic pops.

Re: Percentage with slicer

Anonymous — Tue, 11 Apr 2023 06:38:12 GMT

Hi Anonymous

Please try to use ALL() function

e.g

Grid Percentage = COUNTROWS('Grid Info')/COUNTROWS(ALL('Grid Info'))

Best Regards!

Yolo Zhu