如何计算多列的安全/风险值

Question

如何计算多列的安全/风险值，并为所有列制作饼图

目标是计算在所有列中有多少(安全)和多少(关于风险)。

示例

​

​

​

​

Answer 1

在Power查询编辑器中，使用以下代码创建一个新表-

请将下面代码中的your_table_name替换为原始的表名。

let
    Source = your_table_name,
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Helmet", "Goggels", "Shoes", "Gloves"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Removed Other Columns", {}, "Attribute", "Value"),
    #"Removed Columns" = Table.RemoveColumns(#"Unpivoted Columns",{"Attribute"}),
    #"Grouped Rows" = Table.Group(#"Removed Columns", {"Value"}, {{"Count", each Table.RowCount(_), Int64.Type}})
in
    #"Grouped Rows"

**在结果集中保持位置“-

let Source = your_table_name,
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Location", "Helmet", "Goggels", "Shoes", "Gloves"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Removed Other Columns", {"Location"}, "Attribute", "Value"),
    #"Removed Columns" = Table.RemoveColumns(#"Unpivoted Columns",{"Attribute"}),
    #"Grouped Rows" = Table.Group(#"Removed Columns", {"Location", "Value"}, {{"Count", each Table.RowCount(_), Int64.Type}})
in
    #"Grouped Rows"

输出如下所示-

​

​

带有位置的输出-

​

​

Now您可以使用这个新表创建饼图，最终输出如下所示

​

​