display the count of rows matching some criteria

0 votes

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 2 in Power BI by prasad
• 120 points
38 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.

0 votes

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 by anonymous
• 25,660 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
• 14,070 points
26 views
0 votes
1 answer

DAX : Occurrences of "count"

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

answered Nov 21, 2018 in Power BI by Upasana
• 8,530 points
592 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 in Power BI by Upasana
• 8,530 points
166 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 in Power BI by Upasana
• 8,530 points
381 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 in Power BI by Avantika
• 1,500 points
74 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 40,440 points
41 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 40,440 points
77 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 40,440 points
55 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 in Power BI by Cherukuri
• 25,660 points
25 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 in Power BI by Cherukuri
• 25,660 points
39 views