Reverse Percentage

[Toots]

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, 

[amitchandak]

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

[Toots]

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

[amitchandak]

@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()))

[Toots]

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

[amitchandak · Accepted solution]

@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())

[Toots]

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

Legend! This works perfectly. Thank you