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 Vishu,
Could you please show me how to do it?
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,
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.