display the count of rows matching some criteria

+1 vote

am new to POWER BI. Am having a csv file and i want to achieve the table/slicer with having matching some criteria.

one column in csv file called Errormessage :

it contains below values: 

Errormessage                               startdate

 File -- productid is empty             5/5/2019 
 File -- productid is empty             9/25/2019
 File -- productid is empty             6/18/2019 
 File -- productid is empty             3/11/2019
 File -- productid is empty             2/10/2019
 File -- Connection to DB failed     2/9/2019
 File -- Connection to DB failed     1/8/2019
 File -- Connection to DB failed     4/7/2019
 File -- productid is empty              6/9/2019
 File -- productid is empty             5/8/2019
 File -- productid is empty              7/5/2019
 File -- productid is empty               5/7/2019
 File -- Connection to DB failed        5/6/2019

now, i want to display either in a  slicer/table(i donno which one should i use) the count of ErrorMessages matching cellvalues

"File -- Connection to DB failed" .

also, i wanna display in another table  with startdates and Errormessage column value "File -- productid is empty" .

Aug 3, 2019 in Power BI by prasad
• 130 points
1,289 views
You want to show dates for each message in different tables or show the number of dates for each in one table?

1 answer to this question.

+1 vote

Do you want to show a table with the count of error messages for each type like below?

Using slicer will show only one errormessage for all tables, so you should not use slicer for your question. [like below]

To show dates of each error in different table, follow below steps:

1.Select table visualization, click on Errormessage and startdate and make the table twice( by ctrl+c & ctrl+v).

2. Now clcik on any one of the table, thrn go to visual filters -> Error message -> Select anyone of the message type.

repeat the same with the other table, then you can see dates for different error messages in separate tables.

Hope it helps!. Any queries do revert back.

answered Aug 5, 2019 by anonymous
• 33,030 points

Related Questions In Power BI

0 votes
1 answer

Max count of workspaces per one PRO user

Right now, it is 250, will be ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,540 points
709 views
0 votes
1 answer

DAX : Occurrences of "count"

Try this for creating a calculated column ...READ MORE

answered Nov 22, 2018 in Power BI by Upasana
• 8,620 points
5,740 views
0 votes
1 answer

To expand all lists in a row of lists at the same time without recurring values

Can't promise simple, but I have something ...READ MORE

answered Feb 19, 2019 in Power BI by Upasana
• 8,620 points
6,149 views
0 votes
1 answer

Calculate Total number of Male & Female in the PowerBI report

To achieve what you are looking for, ...READ MORE

answered Feb 28, 2019 in Power BI by Upasana
• 8,620 points
11,268 views
0 votes
1 answer

How to refresh a gateway running on Azure VM?

You can easily resolve this error by ...READ MORE

answered Jun 10, 2019 in Power BI by Avantika
• 1,520 points
1,301 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,520 points
78,862 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

answered Feb 3, 2020 in Power BI by Jitesh
19,167 views
0 votes
1 answer

How to Split Columns in Power BI?

Splitting columns in Power BI using the ...READ MORE

answered Jan 6 in Power BI by anonymous
• 1,380 points
855 views
0 votes
1 answer

Add Column Count_of_people across two tables to get the count of people from a city.

Hi Anitha, 1. Merge both tables, using City ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
1,145 views
0 votes
1 answer

Calculated column with the sum of values from many columns in a row

Hi, You can create a new column by ...READ MORE

answered Mar 14, 2019 in Power BI by Cherukuri
• 33,030 points
2,633 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP