Forum Discussion

amansinghfirstb's avatar
amansinghfirstb
Helper III
5 years ago

Problem in getting % change values

This has been one harrowing tale where so far I have tried every trick in the book to get the answer but nothing has worked so far.  I want something like column F( which uses created column G). The ...
Need Help
amansinghfirstb's avatar
amansinghfirstb
Helper III
5 years ago

This is not coming out right.

 

DataInsights's avatar
DataInsights
Super User
5 years ago

amansinghfirstb,

 

Line 9 should use [Total Qty].

 

Line 11 should use [TotalQty] (no space).

 

It's best practice not to precede measures with a table name.

  • amansinghfirstb's avatar
    amansinghfirstb
    Helper III
    5 years ago

    Thanks, I did the correction, but why am i getting the total like this?

     

     
     
     

    Order Fluctuation% change as 108.81% doesn't make sense. Can I remove it?

     

     

    • DataInsights's avatar
      DataInsights
      Super User
      5 years ago

      amansinghfirstb,

       

      Replace the last line of the measure with this so it will display blank for the total row:

       

      IF ( HASONEVALUE ( Orders[Schedule Ship Wk] ), vResult, BLANK() )

       

      • amansinghfirstb's avatar
        amansinghfirstb
        Helper III
        5 years ago

        DataInsights 

        I noticed something off here. When I put Business column back in the table the order fluctuation goes for a toss. 

        Ideally, all the businesses with common week number should have same order fluctuation % as it is being calculated wrt to the total of the week.