Forum Discussion

Frequent Visitor

8 years ago

Solved

Consolidated Count

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 h...

Need Help

Zubair_Muhammad

8 years ago

seanrm42

Try this calculated Table

New Table =
SUMMARIZE (
    SUMMARIZE (
        TableName,
        TableName[Devices],
        "Count of Apps", COUNT ( TableName[Apps] )
    ),
    [Count of Apps],
    "Count of devices", COUNT ( TableName[Devices] )
)

seanrm42

Frequent Visitor

8 years ago

I created the two tables but am having a struggle getting to the finalized summary view my executive is looking for.

He wants to know how many devices have 1 app, how many devices have 2 apps, how many devices have 3 apps. and so on. The maximum number is 17 and I've compiled the data in excel wiht a pivot table just want it to refresh automatically in PBI from the data source directly.

dramus

Continued Contributor

8 years ago

Given this data: