Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey,
I used https://www.daxpatterns.com/abc-classification-dynamic/ to build the ABC analysis.
I am working with customers and sales. The analysis works but is not exact. Out of 953 users 8 are missing and their sales too.
The rows missing are seemingly random or maybe are saved next to each other on the hard drives, don't know. But they don't have a connection to each other in any other way (Customer, Salesamount, Sale day, sale month, product... ).
The data ist just about the last 3 years and even then not even a million rows. With a slicer i am viewing different years and the numbers missing change from year to year, but they are always the same customers and sales.
Does anyone have an idea why they are missing?
ABCUmsatz = CALCULATE( [Gesamtumsatz]; VALUES(rpt_VK_Historie[KNDNR]); FILTER( CALCULATETABLE( ADDCOLUMNS( ADDCOLUMNS( VALUES(rpt_VK_Historie[KNDNR]); "Äußerer Wert"; [Gesamtumsatz] ); "ZusammengefügterUmsatzProzent"; DIVIDE( SUMX( FILTER( ADDCOLUMNS( VALUES(rpt_VK_Historie[KNDNR]); "Innerer Wert"; [Gesamtumsatz] ); [Innerer Wert] >= [Äußerer Wert] ); [Innerer Wert] ); CALCULATE( [Gesamtumsatz]; VALUES(rpt_VK_Historie[KNDNR]) ) ) ); ALL(rpt_VK_Historie) ); [ZusammengefügterUmsatzProzent] > [MinUntereGrenze] && [ZusammengefügterUmsatzProzent] <= [MaxObereGrenze] ) )
Thanks for your help 🙂
Ok i figured it out. Now i am using Customer groups and Sales. For some reason that works correctly. And if i need the customers it is no problem to just display those out of the customergroups.
Nevermind. The values are corrct again but if a customer is in group A B or C depends now on which customers group he is in. Not exactly what i was looking for.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |