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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
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.

Zaky's avatar
Zaky
Helper IV
7 years ago

Hi,

 

Could you please show steps to do this?

 

Thanks.

  • Vishnu_1980's avatar
    Vishnu_1980
    Frequent Visitor
    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
  • Zaky's avatar
    Zaky
    Helper IV
    7 years ago

    Hi,

     

    Thanks it works perfectly !

  • Zaky's avatar
    Zaky
    Helper IV
    7 years ago

    one more thing..how can i make the % symbol available after the percentage number? mine not shown