cancel
Showing results for
Did you mean:
Regular Visitor

## Count the number of incident, which is less than *

Hi,

I tried to calculate and make tabular format, which total number of records less than 5, less than 3, less than 2 and less than 1.

i could not figure it out how can i achive this as i am totaly new this power BI

1 ACCEPTED SOLUTION
Super User
`CountLT5GT4 = COUNTX(FILTER(Table, Table[Column]<5 && Table[Column]>4),[Column])`

No problem, my pleasure!

Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
Check out my latest book!

5 REPLIES 5
Super User

You would create a couple measures in your data model. Data model tab on the left, Modeling, New Measure. The general formula would be:

`CountLessThan5 = COUNTX(FILTER(Table, Table[Column]<5),[Column])`

Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
Check out my latest book!

Regular Visitor

@Greg_Deckler: Thanks you. Its realy helps me your solution to my earlier posts also. Additionatly, i require to count, which is less than 5 and grater than 4 (like in between). how to define formula for that.

Super User
`CountLT5GT4 = COUNTX(FILTER(Table, Table[Column]<5 && Table[Column]>4),[Column])`

No problem, my pleasure!

Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
Check out my latest book!

Regular Visitor

Thank you.. I realized that, my formula was wrong

Regular Visitor

i am getting result count is zero, if i were use && opeator. i am getting proper result when i use || operator for first condition (COUNTX(FILTER(Feedback,Feedback[Avg]>5 || Feedback[Avg]<= 4),Feedback[Avg]) ).

when i use second condition for different measure field

COUNTX(FILTER(Feedback,(Feedback[Avg]>4 || Feedback[Avg]<=3)),Feedback[Avg])

this returning unexpected count (count is 8). For this condition the result should be two. But i am getting count 8, which are blank fields are also behind.

Announcements

#### Launching new user group features

Learn how to create your own user groups today!