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

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi 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'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