Consolidated Count

[seanrm42]

Hello fellow PBIX users.

I need your help for an executive request that I know is simple but has me stumped.

I have a large table which has a DeviceID and the AppID. For each App the Device has installed there is a row.

Example:

Device 1        App1

Device 2        App1

Device 2        App2

Device 2        App3

Device 3        App2

I need a summarized view that lookcs like this:

Count of Apps        Count of Device 

1                             2

3                             1

Showing the number of devices which have have a certain counts of the apps. We want to start with the devices which have the most apps installed and work our way back.