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

amitchandak's avatar
amitchandak
Super User
6 years ago

rayinOz ,

Create the measures like this and display against the employee ID/Name

total = calculate(distinctCOUNT(table[Course Name ]))
Complete =  calculate(distinctCOUNT(table[Course Name ]), table[Course Status]="Complete")

Flag = if([total]=[Complete],"Yes","No")


Appreciate your Kudos.

 

  • rayinOz's avatar
    rayinOz
    Helper III
    6 years ago

    Hello

     

    Thanks for helping me create the three measures. I've done that, but I am unsure how the display them in a list or graph.... thanks so much. 😄

     

    Ray