Forum Discussion

rayinOz's avatar
rayinOz
Icon for Helper III rankHelper III
9 years ago

Percent Complete by Cohort in different table

Hello,

 

I'm having trouble coming up with a percent of a total that is in a different table.

 

I have two tables "main" which is a list of course enrolments. and I have "users" which is a list of all users in our system.

 

I have the following measures in my "main" table:

 

Total Enrol = CALCULATE(COUNT(Main[Course Name]))
Total Cohort = CALCULATE(COUNT('trainme-users'[profile_field_employeenumber]),FILTER('trainme-users', 'trainme-users'[profile_field_assignmentgroup]="Casual / Honorary"))
Percent Enrolled = [Total Enrol]/[Total Cohort]

When I put the measures into a visualisation card, the numbers (totals) show correctly. Its when I put the Percent Enrolled measure as a value in the bar chart visualisation where things go wrong.  Most of the chart is showing 100%. 

 

Help! LOL.

 

 

 

Thanks for any help.

 

Rayinoz

 

 

 

 

 

 

 

Need Help
Show and Tell

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    rayinOz

     

    Hi, 

     

    The context in the visual will influence the outcome of the formula. You could try a measure like this. Please have a try.

     

    Total Cohort =
CALCULATE (
    COUNT ( 'trainme-users'[profile_field_employeenumber] ),
    FILTER (
        ALL ( 'trainme-users' ),
        'trainme-users'[profile_field_assignmentgroup] = "Casual / Honorary"
    ),
    ALL ( main )
)

     

     

     

    Best Regards!

    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi rayinOz,

     

    Could you please mark the proper post as answer if it worked? More about this topic, please feel free to post here.

    Best Regards!
    Dale

    • rayinOz's avatar
      rayinOz
      Icon for Helper III rankHelper III
      9 years ago

      Hello,

       

      I'm still trying to work the problem. It still isn't working as desired. I'll post another screenshot of what i'm trying to do and I hope that'll help find a good solution. 

       

      Ray