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

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
7 years ago

Hi azeem_3a ,

So are these codes cumulative? What if April was the uncompleted code, and we went Jan - May, and May was completed would we get a zero or a one for that code?

 

Thanks,

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
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