Cannot Convert true to text

Hi Anonymous ,

You can follow these steps to try:

1. Use group by based on 'computer name':

2. Add a custom column using this formula:

=let 
    B = [Data],
    #"Removed Other Columns" = Table.SelectColumns(B,{"Status"}),
    #"Grouped Rows1" = Table.Group(#"Removed Other Columns", {"Status"}, {{"Count", each Table.RowCount(_), type number}}),
    #"Pivoted Column" = Table.Pivot(#"Grouped Rows1", List.Distinct(#"Grouped Rows1"[Status]), "Status", "Count", List.Sum)
    in
    #"Pivoted Column"

3. Remove 'Data' column and expand 'Custom' column

4. Replace values from null to 0 to get the expected result:

My sample file is attached that hopes to help you, please check and try it: Cannot Convert true to text.pbix 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.