Forum Discussion
datadmin-austin
Helper I
3 years agoGroup by Percentage Range
Hello All, I am trying to get a count of percentages within a range, most likely using DAX. See sample below: Data: Inspection Score: 85% 85% 90% 70% 75% 100% 92% 75%...
- 3 years ago
try to create a bunch of measures like:
Scores less than 70% = COUNTROWS( FILTER( TableName, TableName[Score]<0.7 ) ) Scores between 70-79.99% = COUNTROWS( FILTER( TableName, TableName[Score]>=0.7 &&TableName[Score]<=0.799 ) ) Scores between 80-89.99% = COUNTROWS( FILTER( TableName, TableName[Score]>=0.8 &&TableName[Score]<=0.8999 ) ) Scores between 90-99.99% = COUNTROWS( FILTER( TableName, TableName[Score]>=0.9 &&TableName[Score]<=0.9999 ) ) Scores abvoe 99.99% = COUNTROWS( FILTER( TableName, TableName[Score]>0.9999 ) )verified with the multi-row card visual and worked like this:
amitchandak
Super User
3 years agodatadmin-austin , I think you need
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k