Forum Discussion

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

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

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! :)