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
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.

       

      • DataInsights's avatar
        DataInsights
        Super User
        5 years ago

        amansinghfirstb,

         

        Would you be able to provide the expected result and how it is calculated? You can paste the table visual into Excel and create formulas that show the calculation logic.