Forum Discussion
Quick Measure - Percentage Difference
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 , 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 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
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