计算PowerBI中的故障 [英] Count Failures in PowerBI

问题描述

我正在Power Bi中开发一个仪表板，并且试图在下面的列中提出一种可以指示或计算失败次数的方法：

I am developing a dashboard in Power Bi and I am trying to come up with a way by which I can indicate or count the number of "fail"s in the following column:

    **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

第一个问题是，在某些情况下，列中的所有值都是成功的。因此，我不能只是做一个视觉水平过滤器...我相信我需要使用DAX进行某种测量...我已经尝试了大多数计数功能，但是它们似乎都不起作用。

The first problem is that in some cases, all of the values in the column will be "success". So I can't just do a visual level filter... I believe I am in need of some kind of measure using DAX... I have tried most of the count functions, but none of them seem to work.

然后，最终目标是能够显示我在该列中是否有任何失败，然后，如果我这样做，我希望能够进行深入分析行并拉出与该特定行有关的电子邮件（或用户ID或其他信息）。

Then end goal is to be able to show whether or not I have any failures in that column and then if I do, I want to be able to drill down to that row and pull up the email (or user ID or other info) pertaining to that particular row.

推荐答案

您可以创建度量计数状态为失败的行。

You can create a measure to count the rows with status fail.

Count of fails = COUNTROWS(FILTER(Table,[Status]="fail"))

然后，您可以在任何可视化中使用它，并向下钻取以获取行级别的电子邮件。

Then you can use it in any visualization and drill down to get the email in the row level.

让我知道是否有帮助。

这篇关于计算PowerBI中的故障的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！