Forum Discussion
Quick Measure - Percentage Difference
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
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
4 Replies
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]))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
