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. Could you please help with steps?

 

PriorityMetMissedTotal TicketPerformance Achievement
S211011100%
S32820282100%
S49462116859630698.25%
SVIP17851696179699.39%
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

14 Replies