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

I would create the following three measures:

 

 

[# of Users] = 
    COUNTROWS( table )
[# Complete] = 
    SUM ( table[Completion Status] )

 

 

[% Completion Rate] = 
    DIVIDE( [# Complete], [# of Users] )

Then put table[Country Office] in your table visual, along with these two measures: [# of Users] and [% Completion Rate]