Forum Discussion

briankwlo's avatar
briankwlo
Frequent Visitor
4 years ago
Solved

Making a new table from another table with calculation

Hello,   Sample Data: courseid userid fullname completion_state division 1 1 Reading course finished AAA 1 2 Reading course Not finish AAA 1 3 Reading course Not finish ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi briankwlo 

     

    You can create the below measures

     

    Finished = CALCULATE(COUNT(Course[division]),Course[completion_state] = "finished")+0
     
    percentage = DIVIDE([Finished],[Total],0)
     
    Total = CALCULATE(COUNT(Course[division]),ALLEXCEPT(Course,Course[courseid],Course[division]))
     
    This is the output of the measures in the table visual

    If this post helps, Accept it as a solution

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi briankwlo 

 

You can create the below measures

 

Finished = CALCULATE(COUNT(Course[division]),Course[completion_state] = "finished")+0
 
percentage = DIVIDE([Finished],[Total],0)
 
Total = CALCULATE(COUNT(Course[division]),ALLEXCEPT(Course,Course[courseid],Course[division]))
 
This is the output of the measures in the table visual

If this post helps, Accept it as a solution

briankwlo's avatar
briankwlo
Frequent Visitor
4 years ago

It's work! 

Thank you esha_shah2002! 

Have a nice day!