cancel
Showing results for
Did you mean:
Frequent Visitor

## Reverse Percentage

Hi,

I would like to reverse this percentage view. To be 100% - 1.62% = 98.38%

If I then add in 1- at the front it, it then messes with the time analysis.

Any help would be greatly appreciated

Cheers,

1 ACCEPTED SOLUTION
Super User

@Toots , Try

divide([Count Order Lines]-[Cancelled Order Lines],[Count Order Lines])

or
if([Cancelled order line]<>0, divide([count of order line]-[Cancelled order line],[count of order line]),blank())

6 REPLIES 6
Super User

@Toots , Not very clear. Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.

In case you only want to change grand total

if(isfiltered(Table[Week]), divide([Cancelled order line],[count of order line]), 1-divide([Cancelled order line],[count of order line]))

Frequent Visitor

Sorry, On the right track but I would like it all same format as the grand total with 1-

Super User

@Toots , Try these. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

if(not(isfiltered(Table[Week])), divide([Cancelled order line],[count of order line]), divide([count of order line]-[Cancelled order line],[count of order line]))

if(not(isfiltered(Table[Week])), divide([Cancelled order line],[count of order line]), if([Cancelled order line]<>0, divide([count of order line]-[Cancelled order line],[count of order line]),blank()))

Frequent Visitor

This would be perfect if the Total changed also.

DIFOT = if(not(isfiltered('Calendar'[Week #])), divide([Cancelled Order Lines],[Count Order Lines]), divide([Count Order Lines]-[Cancelled Order Lines],[Count Order Lines]))

I will also have to try do up sample data for you
Super User

@Toots , Try

divide([Count Order Lines]-[Cancelled Order Lines],[Count Order Lines])

or
if([Cancelled order line]<>0, divide([count of order line]-[Cancelled order line],[count of order line]),blank())

Frequent Visitor

divide([Count Order Lines]-[Cancelled Order Lines],[Count Order Lines])

Legend! This works perfectly. Thank you

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors