Forum Discussion

azeem_3a's avatar
azeem_3a
Frequent Visitor
7 years ago
Solved

Getting a table from a measures and slicer values

Hi New to power bi, need help on this.    I've a table like this.  Every month a class is given codes which they have to complete the plan. if plan is equal to actual its named as Completed.   ...
  • Nathaniel_C's avatar
    Nathaniel_C
    7 years ago

    Hi azeem_3a ,

    Based on what you have presented I can duplicate your requested output. I have added a column in Power Query, although you can add it in Power BI. Simple if statement comparing the Plan and Actual and if not equal give it a 1. Call it Not completed.  My table is call code. Then a measure.

    Distinct count of projects = DISTINCTCOUNT(code[Code])

    and another

    Completed projects = [Distinct count of projects] - max(code[Not completed])

    works on a card or table. 

     

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel