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
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