Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to 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.
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.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |