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 2, 2019 in Power BI by prasad
• 130 points
139 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
• 32,490 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,410 points
90 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,620 points
2,089 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
1,588 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
2,034 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,500 points
356 views
0 votes
1 answer
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 in Power BI by Jitesh
3,703 views
0 votes
0 answers

How to Split Columns in Power BI?

Can anyone demonstrate how to split columns ...READ MORE

Feb 4 in Power BI by Roshni
• 3,870 points
72 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
• 32,490 points
90 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
• 32,490 points
222 views