Percent Complete by Cohort in different table

[rayinOz]

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

[v-jiascu-msft]

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]

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

[v-jiascu-msft]

@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