Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
i need to create a table-visual, with contains
i already tried a lot but i cannot get it, i hope my post is clear enough, every help is welcome
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?
unfortunately the IT guidlines do not not allow me to publish files on one-drive or else ...
again kind regards Franz
Solved! Go to 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] ) )
Regards,
Xiaoxin Sheng
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
Hi,
Share the link from where i can download your file.
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.
hi,
i hope this is working
or this one
kind regards
franz
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] ) )
Regards,
Xiaoxin Sheng
thanks a lot, this solved my problem
kind regards
Franz
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |