Forum Discussion
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...
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] ) )
Table 1 is exactly like your example and you should have 3 columns
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] )
)