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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Remove all filters except some to calculate % of total selected

liamv_0-1673499303951.png

 

Hi all,

Could you please help me to get the measure for the to get the total number of accounts for each region with A&B slicers applied on page? Use it to calculate the % of actual vs. total accounts with A&B applied.

Measure = CALCULATE(COUNT(Table[Region]), ALLEXCEPT(Table, Table[A]))
will show the total number of accounts without A&B applied.


Appreciate your help

Here the PBIX file:
https://file.io/EIbffHydjc8d

2 REPLIES 2
Anonymous
Not applicable

Thank you. Just updated with the link to PBIX file.

My need is to keep show the percentage of A B C D with Weekly/Monthly already applied
(denominators fixed = 179, 357, 930)

So if I change the state, the % will show as a ratio to these numbers (% of A in that state on total A with Frequency applied).

Thank you so much.

liamv_0-1673509040878.png

 



amitchandak
Super User
Super User

@Anonymous , Based on what I got

 

Measure = CALCULATE(COUNT(Table[Region]), Filter(allselected(Table), Table[A] = max(Table[Table A]) ))

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors