Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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.     ...
General Comment
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , 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())

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , 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()))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , 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())

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

       

      Legend! This works perfectly. Thank you