Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
chethan
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

@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
v-haibl-msft
Microsoft Employee
Microsoft Employee

@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

@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.
BhaveshPatel
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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.