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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Brighton10
Helper II
Helper II

How to calculate percentile values below and above 90 percentile value

Hi powerBI community

 

I have a table that I need to calculate the 90th percentile. I have done some calculations based on some answers on previous topic question but I am stuck on how to visualize percentile count below and above on a card and also on a pie chart. I need assistance to to write DAX to achieve that. I have attached a link to the pbix file. Thanks

 

https://drive.google.com/file/d/1PiViwNl5XFp7tT3OuPiCCF7VwIHzasbd/view?usp=sharing 

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

Hi @Brighton10 

You can try this

"I need the count of Box below the 90 percentile value",

use this measure,

count box bellow 90 = 
   var _value=[90 bo]
return 
   CALCULATE(COUNTROWS(Box_Catch),FILTER(ALL(Box_Catch),Box_Catch[Asset]="Box Office" && Box_Catch[Box movies per user per month]<_value))

 "I need the count of catch below the 90 percentile"

use this measure,

count catch bellow 90 = 
   var _value=[90 cu]
return 
   CALCULATE(COUNTROWS(Box_Catch),FILTER(ALL(Box_Catch),Box_Catch[Asset]="Catchup" && Box_Catch[Box movies per user per month]<_value))

 

Best Regards,

Community Support Team _Tang

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

View solution in original post

1 REPLY 1
v-xiaotang
Community Support
Community Support

Hi @Brighton10 

You can try this

"I need the count of Box below the 90 percentile value",

use this measure,

count box bellow 90 = 
   var _value=[90 bo]
return 
   CALCULATE(COUNTROWS(Box_Catch),FILTER(ALL(Box_Catch),Box_Catch[Asset]="Box Office" && Box_Catch[Box movies per user per month]<_value))

 "I need the count of catch below the 90 percentile"

use this measure,

count catch bellow 90 = 
   var _value=[90 cu]
return 
   CALCULATE(COUNTROWS(Box_Catch),FILTER(ALL(Box_Catch),Box_Catch[Asset]="Catchup" && Box_Catch[Box movies per user per month]<_value))

 

Best Regards,

Community Support Team _Tang

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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