Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Solved! Go to 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 , 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()))
This would be perfect if the Total changed also.
@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())
divide([Count Order Lines]-[Cancelled Order Lines],[Count Order Lines])
Legend! This works perfectly. Thank you
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |