Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi All,
i am trying to calculate percentage on Row wise bust still am not able to do it..
SLA Met & SLA Not Met details in singal coloum.
Please help me on this.
Below is the table look like in excel 2016
App Details | SLA Met | SLA Not Met | Total | SLA Met % | SLA Not Met % |
ABC | 6190 | 1502 | 7692 | 80% | 20% |
QWE | 2805 | 1120 | 3925 | 71% | 29% |
ASD | 688 | 212 | 900 | 76% | 24% |
ZXC | 1693 | 765 | 2458 | 69% | 31% |
TYU | 13794 | 4556 | 18350 | 75% | 25% |
FGH | 23853 | 7818 | 31671 | 75% | 25% |
Total | 49023 | 15973 | 64996 | 75% | 25% |
Thanks in Advance.
Regards,
Chethan
Solved! Go to Solution.
Just create some measures one by one as below should be OK.
SLA Met = CALCULATE ( SUM ( Table2[Resolution time - Bucket in Days] ), FILTER ( Table2, Table2[Resolution time - Bucket] = "SLA Met" ) )
SLA Not Met = CALCULATE ( SUM ( Table2[Resolution time - Bucket in Days] ), FILTER ( Table2, Table2[Resolution time - Bucket] = "SLA Not Met" ) )
Total = CALCULATE ( SUM ( Table2[Resolution time - Bucket in Days] ), ALLEXCEPT ( Table2, Table2[App Details] ) )
SLA Met % = [SLA Met] / [Total]
SLA Not Met % = [SLA Not Met] / [Total]
Best Regards,
Herbert
You can follow the steps mentioned by BhaveshPatel, or you can create two calculated columns as below.
SLA Met % = Table1[SLA Met] / Table1[Total]
SLA Not Met % = Table1[SLA Not Met] / Table1[Total]
Best Regards,
Herbert
Hi
Thanks for replay i have tryed the same its working fine for the table editing or queries Editing their is no problem..
but i need to showcase the date in dashboard am using Matrix Visulation
Below is the my backed table data
Order Number | App Details | Resolution time - Bucket in Days | Resolution time - Bucket |
14578980912 | ABC | 2 | SLA Met |
14578988312 | QWE | 12 | SLA Not Met |
14578988412 | ASD | 1 | SLA Met |
14578990312 | ZXC | 4 | SLA Not Met |
14578999112 | TYU | 10 | SLA Not Met |
14579011012 | FGH | 5 | SLA Not Met |
14579016812 | ABC | 9 | SLA Not Met |
14579020812 | QWE | 1 | SLA Met |
14579022912 | ASD | 4 | SLA Not Met |
14579023712 | ZXC | 8 | SLA Not Met |
14579026012 | TYU | 6 | SLA Not Met |
14579027612 | FGH | 3 | SLA Met |
14579040012 | ABC | 7 | SLA Not Met |
14579043612 | QWE | 1 | SLA Met |
14579051012 | ASD | 7 | SLA Not Met |
14579053512 | ZXC | 1 | SLA Met |
14579058312 | TYU | 4 | SLA Not Met |
14579065112 | FGH | 5 | SLA Not Met |
14579071612 | ABC | 3 | SLA Met |
14579075212 | QWE | 2 | SLA Met |
15579113501 | ASD | 1 | SLA Met |
15579114301 | ZXC | 12 | SLA Not Met |
Below i need to be look like in the dashboard
App Details | SLA Met | SLA Not Met | Total | SLA Met % | SLA Not Met % |
ABC | 6190 | 1502 | 7692 | 80% | 20% |
QWE | 2805 | 1120 | 3925 | 71% | 29% |
ASD | 688 | 212 | 900 | 76% | 24% |
ZXC | 1693 | 765 | 2458 | 69% | 31% |
TYU | 13794 | 4556 | 18350 | 75% | 25% |
FGH | 23853 | 7818 | 31671 | 75% | 25% |
Total | 49023 | 15973 | 64996 | 75% | 25% |
Please help me on this..
Regards,
Chethan
Just create some measures one by one as below should be OK.
SLA Met = CALCULATE ( SUM ( Table2[Resolution time - Bucket in Days] ), FILTER ( Table2, Table2[Resolution time - Bucket] = "SLA Met" ) )
SLA Not Met = CALCULATE ( SUM ( Table2[Resolution time - Bucket in Days] ), FILTER ( Table2, Table2[Resolution time - Bucket] = "SLA Not Met" ) )
Total = CALCULATE ( SUM ( Table2[Resolution time - Bucket in Days] ), ALLEXCEPT ( Table2, Table2[App Details] ) )
SLA Met % = [SLA Met] / [Total]
SLA Not Met % = [SLA Not Met] / [Total]
Best Regards,
Herbert
Hi Chetan
I have created a solution using Query Editor, Thanks@Herbert_Liu for posting a DAX Solution.
Please follow the attached screenshots for the solution created by Query Editor
Groupby Operation
Pivot Column
Added Custom Column
Created Calculated column
Created another Calculated column
Changing the percentage format of the column
Hi Chethan,
You can use Quick Calc functionality in PowerBI to achieve expected results without writing any DAX.
For more info, See this VIDEO.
Alternatively, You can use DAX for this Calculation, More work but can learn you intuitive behaviour of DAX.
Create 2 measures,
For Grand Total
GrandTotal:=CALCULATE(SUM(SLA[SLA Met]),ALL(SLA))
SLA -- Name of your Table
SLASUM:=SUM(SLA[SLA Met])
Percentage:=DIVIDE([SLASUM],[GrandTotal],2)
Similarly, Create the measures for SLA Not met as well.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
80 | |
79 | |
59 | |
36 | |
35 |
User | Count |
---|---|
99 | |
57 | |
56 | |
46 | |
40 |