How to calculate percentile values below and above 90 percentile value

[Brighton10]

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 

[v-xiaotang · Accepted solution]

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.