cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBNikr
Helper I
Helper I

DAX: How to calculate percentage (slicer choice) from fixed total value

 

I have a report where the user can use slicers to filter out a certain amount of people based on those values. Three different values are shown:

 

  • Total amount of people (fixed number)
  • Amount of people after slicer choice 
  • Percentage of people after slicer choice

How can I calculate the percentage using DAX?

 

Example:

 

Total = 400

After slicer choice = 44

Percentage = 11%

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

I have that as part of my The Most Amazing, Mind Blowing Dynamic Slicer Title Measure Ever quick measure:

 

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer...


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
v-jiascu-msft
Microsoft
Microsoft

Hi @PBNikr,

 

Could you please mark the proper answers as solutions?

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User
Super User

I have that as part of my The Most Amazing, Mind Blowing Dynamic Slicer Title Measure Ever quick measure:

 

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer...


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

This is great! 

 

We decided to bring in the measure directly from the cube - just a better alternative for us.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors