Counting rows containing a percentage and grouping

[CarolynM]

I have a table that contains a column with '% Complete' - which tracks progress of a task. I want to display, in a stacked column chart, how many tasks are within a range of 0-25%, 26-50%, 51-75% , 76-100%. 

I have used the below formulas but can't seem to achieve what I need.

Form Progress 0-25% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete]=0-0.25))

Form Progress 26-50% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete]=0.26-0.5))

Form Progress 51-75% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete]=0.51-0.75))

Form Progress 76-100% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete]=0.76-1))

Would appreciate some help please! 

[CarolynM]

Thank you @dharmendars007 !! That worked perfectly. 

The formula I was previosuly trying to use was telling me I had too few arguments. 

I've only started using Power BI in the last week, so very new at it! 

[dharmendars007 · Accepted solution]

Hello @CarolynM , 

Please try the below revsied code i have modified the same using your code..

Form Progress 0-25% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete] >= 0 && 'Master List'[% Complete] <= 0.25))

Form Progress 26-50% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete] > 0.25 && 'Master List'[% Complete] <= 0.5))

Form Progress 51-75% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete] > 0.5 && 'Master List'[% Complete] <= 0.75))

Form Progress 76-100% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete] > 0.75 && 'Master List'[% Complete] <= 1))

Alos am curious to know the error you are getting on the visual when you were trying 

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN