Forum Discussion

Zaky's avatar
Zaky
Helper IV
7 years ago
Solved

Need Help - Pivot table

Hi,   I'm new in Power BI. My question is how to create Pivot table (like excel) dashboard in Power BI? I want to get performance achievement percentage for each priority rows as per table below. C...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    Try these measures:

     

    Met = CALCULATE(COUNTROWS(Table1),Table1[MeasurementStatus]="Met")

    Missed = CALCULATE(COUNTROWS(Table1),Table1[MeasurementStatus]="Missed")

    Total = [Met]+[Missed]

    Performance (%) = [Met]/[Missed]

     

    Hope this helps.

  • Vishnu_1980's avatar
    Vishnu_1980
    7 years ago

    Hi ,

     

    Please find the attached screen shot.Kindly have a look and confirm me if anything required.IF performance percentage needs to calcualte, we need create few measure.New is the table name 

     

    With the help of ashish mathur code i ahve created four measure.

     

    Please find below the code as he given:

     

    Met = CALCULATE(COUNTROWS(New),New[MeasurementStatus]="Met")
    Missed = CALCULATE(COUNTROWS(New),New[MeasurementStatus]="Missed")
    Total = 'New'[Met]+'New'[Missed]
    Performance percentage = 'New'[Met]/'New'[Total]
     
    Once we created kindly use matrix table
     
    Thanks
AlB's avatar
AlB
Community Champion
7 years ago

Hi Zaky

You can use the matrix visual. It works pretty much like a pivot table

Zaky's avatar
Zaky
Helper IV
7 years ago

Hi AIB,

 

I did used matrix visual, but the question is how to get percentage for each Priority rows.

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Zaky

     

    Place [Priority] in the rows of the matrix and [Performance Achievement] on values of the matrix?

    • Vishnu_1980's avatar
      Vishnu_1980
      Frequent Visitor
      7 years ago

      Hi 

       

      PLease find the screen of the table and confirm it satisfies your requirement

       

      If this not your requirement, kindly share some sample output

       

      • Zaky's avatar
        Zaky
        Helper IV
        7 years ago

        Hi Vishnu,

         

        Yes, I want to get the percentage performance of the ticket total.

         

         

        Thanks