Forum Discussion

Mike35's avatar
Mike35
Frequent Visitor
1 year ago
Solved

Calculating a percentage between two tables

Hi all,   Trying to calculate a percentage between two tables with the below coding, and struggling to get an ouput. Wondered if anyone can point me in the direction of where I am going wrong?   ...
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    Mike35 Measure for the count of quiz results per area:

    QuizResultsCount = COUNTROWS('Quiz Results')

     

    Measure for the count of staff per base:

    StaffCount = COUNTROWS('Staff Base')

     

    Measure to calculate the completion percentage:

    DAX
    AreaCompletion% =
    DIVIDE(
    [QuizResultsCount],
    [StaffCount]
    )

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

Mike35 Measure for the count of quiz results per area:

QuizResultsCount = COUNTROWS('Quiz Results')

 

Measure for the count of staff per base:

StaffCount = COUNTROWS('Staff Base')

 

Measure to calculate the completion percentage:

DAX
AreaCompletion% =
DIVIDE(
[QuizResultsCount],
[StaffCount]
)