Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
FranzMei
Helper I
Helper I

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)

basic databasic 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

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
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

9 REPLIES 9
ImkeF
Super User
Super User

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

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

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

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.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Ashish_Mathur
Super User
Super User

Hi,

 

Share the link from where i can download your file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

Hi @FranzMei,

 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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
If this post helps, please consider accept as solution to help other members find it more quickly.

thanks a lot, this solved my problem

kind regards

Franz

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.