Forum Discussion

thomasOfver's avatar
thomasOfver
Frequent Visitor
8 years ago
Solved

Help with creating table

Hi! I have a table with three columns: Country Office, User, and Completion Status (1 or 0). I also have the measure "Completion Rate", which just takes the average of the Completion Status column an...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    8 years ago

    You can try to use GROUPBY function to get this kind of summary information.

     

    NewTableName = GROUPBY('ExistingTableName','ExistingTableName'[Country],"Count of Users",COUNTX(CURRENTGROUP(),'ExistingTableName'[Users]),"Completion Rate", AVERAGEX(CURRENTGROUP(),SUM'ExistingTableName'[Completion Status]/COUNT'ExistingTableName'[Users]))

     

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi thomasOfver,

 

To achieve your requirement, I think you can try SUMMARIZE() function. Please refer to following sample:

 

New Table =
SUMMARIZE (
    'Table',
    'Table'[Country Office],
    "Count Of User", COUNT ( 'Table'[Users] ),
    "Completion Rate", DIVIDE (
        SUM ( 'Table'[Completion Status] ),
        COUNT ( 'Table'[Completion Status] )
    )
)

 

Thanks,

Xi Jin.