Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

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])) 

aahmad28_0-1680732608938.png

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.

 

aahmad28_1-1680732694281.pngaahmad28_2-1680732754917.png

 

1 ACCEPTED SOLUTION

Hi @Anonymous 

Please try to use ALL() function

e.g 

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

 

Best Regards!

Yolo Zhu

 

View solution in original post

6 REPLIES 6
v-xinruzhu-msft
Community Support
Community Support

Hi @Anonymous 

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

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

vxinruzhumsft_0-1680833465527.png

 

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

vxinruzhumsft_1-1680833503465.png

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.

 

Anonymous
Not applicable

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.

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.

 

Anonymous
Not applicable

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.

Hi @Anonymous 

Please try to use ALL() function

e.g 

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

 

Best Regards!

Yolo Zhu

 

Anonymous
Not applicable

Any help on this please?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors