3 Replies Latest reply on Mar 21, 2017 7:21 AM by Jim Dehner

    Measure Names dropping out of filter when I edit a calculation

    Ben Powis

      Hello everyone,

       

      I am trying to make a tweak to a calculation in the workbook below so that 'Transactions % of total' on the Measure Values shelf computes using the 'segment', which will then make my 'percentage of total' calculation correct - as you will see below the percentages are incorrectly based on both pie charts, not each as individuals. However, when I make this change Measure Names is dropping out of the filter - I filter these pie charts by Measure Name so I need this to stay in place.

       

      Can anyone tell me why this is happening and if possible suggest a way to achieve the correct percentage calculation? My current percentage calculation is SUM([Transactions])/TOTAL(SUM([Transactions]))

       

      Thank you,

      Ben

      Jump.PNG