Forum Discussion

rayinOz's avatar
rayinOz
Helper III
6 years ago
Solved

Custom 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...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hello

    You can download my PBI file from here.

    I hope this helps.

    Untitled.png

rayinOz's avatar
rayinOz
Helper III
6 years ago

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's avatar
Ashish_Mathur
Super User
6 years ago

Hello

You can download my PBI file from here.

I hope this helps.

Untitled.png

  • rayinOz's avatar
    rayinOz
    Helper III
    6 years ago

    Thank you! You have given me everything I need!! WHEW!!!! Boss happy now. 😄

     

    Kind regards

    Ray