Collapsing Fields and Visuals - MEMCM/SCCM Reporting

[mtucci3]

Hi all - This may be an elementary question as I've recently started diving into SCCM reporting using Power BI. Please advise if I'm not posting in the correct area. I've been able to create some useful visuals so far, but with simple single datasets.

What I have now is a table that pulls duplicate values in a few columns (resource ID, net bios name). In SQL/SSRS, I'm able to collapse the values.

For example, my query looks for any device in our environment that has a required MS update that is not installed, and will generate a compliance status of "Not Compliant" and so-forth. Because of this, I'm having trouble creating a visual where it shows correct numbers.

Here's what I see in SSRS:

I have it structured to expand by machine name. 

Here's what I have in Power BI:

Here, each resource ID and machines name is associated to each update value.

I'd like to create a visual of the overall compliacne of only one machine, say "count of machines where = compliant or not compliant".

Can someone help give me a nudge on this one?

Thank you!