Forum Discussion
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,
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
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]))
Sorry, On the right track but I would like it all same format as the grand total with 1-
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()))
