Forum Discussion

azeem_3a's avatar
azeem_3a
Frequent Visitor
6 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
    6 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
6 years ago

azeem_3a ,

Go to power query, and create a conditional column as in pic, then add your slicer with the dates, add a table, with Class, and then add the conditional column, using the arrow, select sum. See pic. Make sure your new col is of type whole number.

 

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