Forum Discussion
rayinOz
Helper III
Helper IIICustom column, measure or table
Hello community I have a dataset that has two courses per employee (employeeID). Course A and Course B. Each course will have a status "complete" or "incomplete". EmployeeID | Course Name | C...
V-lianl-msft
Community Support
Community SupportHi rayinOz ,
Please try to create a calculated column and apply in visual level filter.
Y/N = CALCULATE(COUNT('Table'[Course Name]),FILTER(ALLEXCEPT('Table','Table'[EmployeeID]),'Table'[Course Status]="Complete"))
Then create a measure like this:
PERCENTAGE_ = DIVIDE(CALCULATE(DISTINCTCOUNT('Table'[EmployeeID]),FILTER(ALL('Table'),'Table'[Y/N]=2)),CALCULATE(DISTINCTCOUNT('Table'[EmployeeID]),ALL('Table')))
For more details,you can refer to the pbix.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- rayinOz
YES... almost there. This solution is gonna work me thinks.
Follow up. IF both courses are listed as incomplete, the field has a null value.. how do I make it a zero?
Y/N = CALCULATE(COUNT('MI and Cyber (2)'[Course Name]), FILTER(ALLEXCEPT('MI and Cyber (2)','MI and Cyber (2)'[Username]), 'MI and Cyber (2)'[UoM Status]="Completed"))- Ashish_Mathur
Super User
- rayinOz
Thank you! You have given me everything I need!! WHEW!!!! Boss happy now. 😄
Kind regards
Ray
