Quick Measure - Percentage Difference

[Anonymous]

Hello experts,

How can I arrive a percentage difference for Completion and what is a correct calculation I need to select in Quick measure. Here is my data inputs.

Total Number of Employees = 1000 Employees with Column  named as (User Name)

Completion status is captured in another column as = Complete (Y) and NOT Complete (N).

I have maintained completion status for all the row against the employee number

Example = Completed 200 (Y) and NOT Completed (N). What is the

[Anonymous]

Hi Amit,

It worked, after entering formula like this

Complete% = DIVIDE(CALCULATE(COUNT(UserCurriculumStatusSummaryCSV[User ID]),FILTER(UserCurriculumStatusSummaryCSV,UserCurriculumStatusSummaryCSV[Completed]="Y")),CALCULATE(COUNT(UserCurriculumStatusSummaryCSV[User ID])))

[amitchandak]

@Anonymous , Measure like this should work at all level

Complete % = divide(calculate(count(Table[employee name]),filter(Table, Table[status] ="Y")), count(Table[employee name]))
Not Complete % = divide(calculate(count(Table[employee name]),filter(Table, Table[status] ="N")), count(Table[employee name]))

[Anonymous · Accepted solution]

Hi Amit,

I am trying to understand the logic you have written.

Complete % = divide(calculate(count(Table[employee name]),filter(Table, Table[status] ="Y")), count(Table[employee name]))

And this will one will bring the NOT completed status.

Not Complete % = divide(calculate(count(Table[employee name]),filter(Table, Table[status] ="N")), count(Table[employee name]))

How I am can divide this syntax to arrive the output percentage?

Do I need to write these login in the same Measure or as a separate measure?

this one will arrive the total number of users completed in Y

[Anonymous]

HI Amit, I am getting an error, Would you be able to help to guide me the normal navigation steps and the appropriate Calculation steps I can select for this in the Quick Measures