cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lalithakiran
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.

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

1 ACCEPTED SOLUTION

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

No problem, my pleasure! 


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User
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])

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

@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.

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

No problem, my pleasure! 


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

View solution in original post

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

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.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!