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

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

    • 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