Forum Discussion
Solved
Group 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%...
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:
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:
FreemanZ Thank you very much! This is much more simple and managable.