cancel
Showing results for
Search instead for
Did you mean:
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

 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

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft

@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

6 REPLIES 6
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

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

Best Regards,

Herbert

Resolver III

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

Microsoft

@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

Resolver III

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

Thanks

Community Champion

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 OperationPivot ColumnAdded Custom ColumnCreated Calculated columnCreated another Calculated 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

#### Check it Out!

Click here to read more about the November 2020 Updates!

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform October Community Highlights

Check out the top community contributors across all of the communities

#### 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