Calculate re-occurances of employee name in a table, also filtering on only Windows devices

[Blue407]

In PowerBi I have a table which is a export from Microsoft Entra of all devices that are in the database, device name, operating system, asigned user etc.

I have a forumla I have created which works ok to give me a column of how many devices each user name appears against:-

UserWindowsDevicesCount = calculate(
COUNTROWS(EntraDeviceReport),
ALLEXCEPT(EntraDeviceReport, EntraDeviceReport[Owners]))

I have realised its reporting all devices and not just Windows devices that I want for this report.

So I tried to add an additional filter, but its not working, it just gives a total number of Windows devices in the list and not per user (owner).

UserWindowsDevicesCount = calculate(

    COUNTROWS(EntraDeviceReport),

    FILTER(EntraDeviceReport,EntraDeviceReport[Operating System]="Windows"),

    ALLEXCEPT(EntraDeviceReport, EntraDeviceReport[Owners]))

Can anybody help?

Thanks in advance 🙂

[rajendraongole1 · Accepted solution]

Hi @Blue407 - We can directly add the filter in the measure, not require filter function again,  and modify your formula to count only the Windows devices per user

UserWindowsDevicesCount = CALCULATE(
COUNTROWS(EntraDeviceReport),
EntraDeviceReport[Operating System] = "Windows",
ALLEXCEPT(EntraDeviceReport, EntraDeviceReport[Owners])
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Blue407]

Thats perfect, thankyou for such a fast response 🙂 🙂