Direct Query - Two counts in the same visual with different filters

Hi  ResearchKnell ,

First fill in the blanks of "Subject_Type" use below M codes:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjMzMTMwUNJRCi5NykpNLgGywnXDPTxDXEFiocEBrs4hQJZSrA6S2rDM5JLMXCDDUdcx2NPRTz/A0dnTzdNZwd/Z1dEPpFxHydPPxTPM0yXU0QdVr3N+bkFOYmZeYl4JfgOUYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [INC_ID_Key = _t, Name_Type = _t, Race = _t, Subject_Type = _t, Victim_Type = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"INC_ID_Key", Int64.Type}, {"Name_Type", type text}, {"Race", type text}, {"Subject_Type", type text}, {"Victim_Type", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Table.Max(Table.SelectRows(Source,each [INC_ID_Key]=[INC_ID_Key]),"Subject_Type")),
    #"Expanded Custom" = Table.ExpandRecordColumn(#"Added Custom", "Custom", {"Subject_Type"}, {"Custom.Subject_Type"})
in
    #"Expanded Custom"

And you will see:

Then you could filter the rows and get the counts.

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!