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
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!