Forum Discussion

seanrm42's avatar
seanrm42
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's avatar
    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] )
)
Yggdrasill's avatar
Yggdrasill
Responsive Resident
8 years ago
SummarizedTable = SUMMARIZE( Table1 ;
    Table1[DeviceID];
    "#ofDev" ; DISTINCTCOUNT( Table1[DeviceID] ) ;
    "#ofApps" ; COUNTROWS( Table1 ) 
)

Then create a group from "#ofApps" and size of the bin is just 1

 

seanrm42's avatar
seanrm42
Frequent Visitor
8 years ago

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.

  • Yggdrasill's avatar
    Yggdrasill
    Responsive Resident
    8 years ago
    Table 1 is exactly like your example and you should have 3 columns
    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      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] )
)