locked
Cummulative adding to create a filter RRS feed

  • Question

  • Hi,

    I am trying to create a version of the Pareto Principle where I have been able to calculate what the %value a specific product has of overall invoicing. What I have been trying to write in DAX is a way to add these %values in a cummulative manner to, eventually, have a 100% value.

    Say there are 50 product codes, Product1=5%, Product2=4.8% etc... I am trying to then be able to to select those product codes which equal to 80% of invoicing. To make matters more fun, I have several product divisions, so this needs to be taken into account while adding the %value.

    Don't know if this makes any sense, I know that my brain is starting to hurt just pondering a solution ;-)

    Thanks for any help/feedback,

    Willem

    Monday, September 10, 2012 3:29 PM

Answers