cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver III
Resolver III

percentage calculator on Row wise

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

 

Persentage.png

 

App DetailsSLA MetSLA Not MetTotalSLA Met %SLA Not Met %
ABC61901502769280%20%
QWE28051120392571%29%
ASD68821290076%24%
ZXC1693765245869%31%
TYU1379445561835075%25%
FGH2385378183167175%25%
Total49023159736499675%25%

 

Thanks in Advance.

 

Regards,

Chethan

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

percentage calculator on Row wise_2.jpg

 

Best Regards,

Herbert

View solution in original post

6 REPLIES 6
Community Champion
Community Champion

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.

 

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Microsoft
Microsoft

@chethan

 

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]

percentage calculator on Row wise_1.jpg

 

Best Regards,

Herbert

Hi 

@v-haibl-msft & @BhaveshPatel

 

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 NumberApp DetailsResolution time  - Bucket in DaysResolution time  - Bucket
14578980912ABC2SLA Met
14578988312QWE12SLA Not Met
14578988412ASD1SLA Met
14578990312ZXC4SLA Not Met
14578999112TYU10SLA Not Met
14579011012FGH5SLA Not Met
14579016812ABC9SLA Not Met
14579020812QWE1SLA Met
14579022912ASD4SLA Not Met
14579023712ZXC8SLA Not Met
14579026012TYU6SLA Not Met
14579027612FGH3SLA Met
14579040012ABC7SLA Not Met
14579043612QWE1SLA Met
14579051012ASD7SLA Not Met
14579053512ZXC1SLA Met
14579058312TYU4SLA Not Met
14579065112FGH5SLA Not Met
14579071612ABC3SLA Met
14579075212QWE2SLA Met
15579113501ASD1SLA Met
15579114301ZXC12SLA Not Met

 

Below i need to be look like in the dashboard

 

App DetailsSLA MetSLA Not MetTotalSLA Met %SLA Not Met %
ABC61901502769280%20%
QWE28051120392571%29%
ASD68821290076%24%
ZXC1693765245869%31%
TYU1379445561835075%25%
FGH2385378183167175%25%
Total49023159736499675%25%

 

Please help me on this..

 

Regards,

Chethan 

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

percentage calculator on Row wise_2.jpg

 

Best Regards,

Herbert

View solution in original post

@v-haibl-msft Thank a ton... its work great..

Thanks

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 OperationGroupby OperationPivot ColumnPivot ColumnAdded Custom ColumnAdded Custom ColumnCreated Calculated columnCreated Calculated columnCreated another Calculated columnCreated another Calculated columnChanging the percentage format of the columnChanging the percentage format of the column

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors