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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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!