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] ) )
Which of the new tables (Apps or Devices) does 'Table 1' represent in your formula?
When I created your formula I got 3 columns instead of 1.
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] ) )