有没有办法创建基于特定列和度量输出的度量？
我有一个数据集，其中包含警报 ID、时间、日期、区域和类型。我想统计有多少警报从低级升级到高级，有多少警报没有升级。
该数据集的预期输出为：
- 升级的警报计数 = 1（ID 号 001）
- 未升级的警报计数 = 1（ID 号 002）
我创建了多个度量来显示警报是否升级（我们将称这些为“升级”），但这些仅当表列是 ID 号并升级时才有效。所有升级的措施都导致未升级的警报计数 = 2。我认为这是因为 ID 号 001 有一个低和高的结果，所以两者都算作 001。
任何想法都会真正应用！
I have a dataset which has alarm IDs, the time, date, area and type. I would like a count of how many alarms escalated from low to high and how many didn't.
The expected output from this data set is:
- Count of alarms that escalated = 1 (ID number 001)
- Count of alarms that did not escalate = 1 (ID number 002)
I have created multiple measures which show whether the alarm escalated (we'll call those all 'escalated') but these all only work when the table columns are ID numbers and escalated. All escalated measures have resulted in count of alarms that did not escalate = 2. I think this is because ID number 001 has a low and high result so both are counted for 001.
Any ideas would be really applicated!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
创建新表来实现
通过使用警报升级 =
总结（
Sheet1,Sheet1[区域],"升级",
不同计数(
Sheet1[报警类型]
）
）
这使我能够看到任何具有不止一种警报类型的区域的计数为 2，从而导致升级。
Achieved by creating a new table using
Alarm escalation =
SUMMARIZE(
Sheet1,Sheet1[Area],"Escalation",
DISTINCTCOUNT(
Sheet1[Alarm type]
)
)
This allowed me to see a count of 2 of any area that had more than one alarm type and therefore escalation.