cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FranzMei Frequent Visitor
Frequent Visitor

ABC Analyse; cumulative sum and percentage

Hello everybody, i am new in forum, working with PowerBI quite a while but unfortunately after wasting a lot of hours i cannot find any proper solution for following issue:

 

i have a prepared data table which already contains prepared datas (time-range, item groups), i need to create an ABC analsye, similar to "Pareto"

 

my data table is this (no dates, no duplicates)

shot.PNGbasic data

 i need to create a table-visual, with contains

  1. item number
  2. sum of sales € 2016
  3. cumulative sum of column "€ 2016", dynamically responding to slicer with column "sub group of Item"
  4. cumulative percentage of column "€ 2016", also responding to slicer with column "sub group of Item"

i already tried a lot but i cannot get it, i hope my post is clear enough, every help is welcome Smiley Happy

 

thanks a lot in advance, kind regards

Franz

 

EDIT, i created and uploaded a sample file, which, as far i can see has just one problem, my measure

total sum of sales = CALCULATE(SUMX('sample';'sample'[Sales €]);ALLSELECTED('sample'[Sales €]))

should bring the sum of roughly 34,000.000 € in every row per itemnumber (and respond to filters on the page), how can i do this?

 

shot.PNG

unfortunately the IT guidlines do not not allow me to publish files on one-drive or else ...

 

again kind regards Franz

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: ABC Analyse; cumulative sum and percentage

Hi @FranzMei,

 

I add a conditional to let measure work with current item, maybe you can try it.

total sum of sales =
CALCULATE (
    SUM ( 'sample'[Sales €] ),
    ALLSELECTED ( 'sample' ),
    VALUES ( 'sample'[Itemnumber] )
)

9.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
9 REPLIES 9
Super User
Super User

Re: ABC Analyse; cumulative sum and percentage

Hi,

 

Share the link from where i can download your file.

Super User
Super User

Re: ABC Analyse; cumulative sum and percentage

Did you try this out already?:  http://www.daxpatterns.com/abc-classification-dynamic/

 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




FranzMei Frequent Visitor
Frequent Visitor

Re: ABC Analyse; cumulative sum and percentage

Hi, thanks for your quick reply, i am sorry; IT guidelines are unabling access to one drive or else, is there an opportunity to send via mail?

 

thanks a lot,

Franz

FranzMei Frequent Visitor
Frequent Visitor

Re: ABC Analyse; cumulative sum and percentage

hi, thanks a lot, i tried, looks nice it does all at in one measure, i have troubles to "translate" th measure to my data's

at this moment it seems to be too high for me;-)

 

kind regards

Franz

Super User
Super User

Re: ABC Analyse; cumulative sum and percentage

How about the slicing and dicing on "Item Grouop"? Is this still an issue? Otherwise you could use the static segmentation which is much easier and there are more learning resources around.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Super User
Super User

Re: ABC Analyse; cumulative sum and percentage

Hi @FranzMei,

 

You may create a dummy dataset, upload it to Google Drive and then share the download link.

FranzMei Frequent Visitor
Frequent Visitor

Re: ABC Analyse; cumulative sum and percentage

Community Support Team
Community Support Team

Re: ABC Analyse; cumulative sum and percentage

Hi @FranzMei,

 

I add a conditional to let measure work with current item, maybe you can try it.

total sum of sales =
CALCULATE (
    SUM ( 'sample'[Sales €] ),
    ALLSELECTED ( 'sample' ),
    VALUES ( 'sample'[Itemnumber] )
)

9.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Highlighted
FranzMei Frequent Visitor
Frequent Visitor

Re: ABC Analyse; cumulative sum and percentage

thanks a lot, this solved my problem

kind regards

Franz