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]))

     

Anonymous's avatar
Anonymous
Not applicable
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]))

 

  • thomasOfver's avatar
    thomasOfver
    Frequent Visitor
    8 years ago
    Anonymouswrote:

    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]))

     


    This totally did the trick - thank you! :)