Forum Discussion
Need Help - Pivot table
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.
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 tableThanks
Hi,
Sorry for the delay in response.Please find below the screen and let me its working or not ? Thanks
Hi Vishnu,
Let says i have the data as per below.
My point is to have Performance Achievement for total of Met/Missed*100. So you will get the percentage.
| Incident ID | Summary | Status | Severity | Customer Full Name | MeasurementStatus | Closed Date |
| ICT_INC00000203 | Installing software | Closed | S4 | M Azim B Omar (BFC&P-TRM/PET-ICT) | Met | 16/02/2017 8:50 |
| ICT_INC00000026 | Report an Issue - Other ICT Issue | Closed | S4 | M Fadhil B Hassan Basri (PMO/Upstream) | Met | 15/02/2017 11:50 |
| ICT_INC00006521 | Report an Issue - Application | Closed | S4 | M Azhari Jahin (PTEC/EPEMSB) | Met | 21/02/2017 16:08 |
| ICT_INC00000236 | user unable to login to wireless reimagine | Closed | S4 | Nurul Hazwani Bt Ahmad Shokri (TES/PCFSSB) | Met | 15/02/2017 9:50 |
| ICT_INC00001175 | Windows: Unable to login to computer due to domain issue | Closed | S4 | Maziatul Akma Fadzlina M Fadzil (FINANCE/PCGB) | Met | 08/02/2017 10:16 |
| ICT_INC00000570 | Hardware - Screen issue (Laptop) | Closed | S4 | Trijono Hadi Wibowo (PMO/Upstream) | Missed | 15/02/2017 12:50 |
| ICT_INC00001186 | Bitlocker-To-Go: Password failure (Unable to unlock) | Closed | S4 | Irwan B M Faizal Din Chan (PMO/Upstream) | Missed | 15/02/2017 10:50 |
| ICT_INC00001194 | Hardware - Docking Station related issues | Closed | SVIP | Zahariah Bt A Rahman (GSC/PETH) | Missed | 16/02/2017 9:51 |
| ICT_INC00000572 | Network : Unable to connect to LAN | Closed | S4 | W Nor Ezah Bt W A Rahman (FS2/PETH) | Met | 15/02/2017 17:50 |
The result supposed to be like below table which is i pivot in excel. I want in Power BI to visualize the Performance percentage right after Total Ticket column.
| Severity | Met | Missed | Total Ticket |
| S4 | 6 | 2 | 8 |
| SVIP | 1 | 1 | |
| Grand Total | 6 | 3 | 9 |
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 tableThanksHi,
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.
Hi,
Could you please show steps to do this?
Thanks.
Hi,
Thanks it works perfectly !
one more thing..how can i make the % symbol available after the percentage number? mine not shown