Forum Discussion

Toots's avatar
Toots
Frequent Visitor
5 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
    5 years ago

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

amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
Toots
Frequent Visitor
5 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
    Super User
    5 years ago

    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's avatar
      Toots
      Frequent Visitor
      5 years ago

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

       

      Legend! This works perfectly. Thank you