Power BI : Counting Failures

0 votes

I am trying to develop a dashboard in Power BI. What I am trying, is to come up with a way through which I can indicate or count the number of failures in the following columns:

    **Status**      Column2      Column3    Column4
    success         data         numbers    email
    success         data         facts      email
    fail            data         figures    email
    success         moredata     science    email
    success         somuchdata   magic      email
    success         stuff        etc        email
    success         things       etc        email

The objective is to be able to show whether or not I have any failures in a particular column. If I do, I want to be able to drill down to that row and pull up the email pertaining to that particular row.

Apr 5, 2019 in Power BI by Shubham
• 13,380 points
46 views

1 answer to this question.

0 votes

Try the following measure:

Count of fails = COUNTROWS(FILTER(Table,[Status]="fail"))
answered Apr 5, 2019 by Upasana
• 8,590 points

Related Questions In Power BI

+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,060 points
979 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,030 points
210 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 51,830 points
203 views
0 votes
1 answer

Programmatically sign in - power bi

Basically: POST request to: https://login.microsoftonline.com/common/oauth2/token Body, form-url-encoded: grant_type: "password" scope: "openid" resource: "https://analysis.windows.net/powerbi/api" client_id: ...READ MORE

answered Sep 19, 2018 in Power BI by Kalgi
• 51,830 points
187 views
+3 votes
2 answers

Combine tables in Power BI

You can also achieve this using a ...READ MORE

answered Oct 5, 2018 in Power BI by lina
• 8,200 points

edited Oct 11, 2018 by Kalgi 368 views
0 votes
1 answer

Power Bi Dax Table

You need to wrap the numbers in ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 51,830 points
176 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

answered May 22, 2019 in Power BI by VNK
12,197 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 51,830 points
14,670 views
0 votes
1 answer

How can i see my plugin name in the Power BI Visual plugin List ?

there is a couple of errors in your ...READ MORE

answered Nov 8, 2018 in Power BI by Upasana
• 8,590 points
99 views
0 votes
1 answer

Error:connecting to Azure SSAS server in Power-BI through Import mode

If I understand correctly, you're connecting to ...READ MORE

answered Nov 9, 2018 in Power BI by Upasana
• 8,590 points
559 views