Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Need Help Dynamic segmentation ABC/XYZ

    Posted Apr 07, 2022 05:06 PM
    Edited by christophe cluzel Apr 07, 2022 05:08 PM
      |   view attached
    Hi I am trying to create a dynamic segmentation ABC/XYZ following the tutorial : https://www.daxpatterns.com/abc-classification/I can without problem create a ABC segmentation and a XYZ segmentation, but I need to have the both at the same time.
    for context :
    ABC is a basic pareto: A = 80% of Value sold, B = 15% of Value and C=5% of Value Sold
    XYZ is the measure of the variability using the Coefficient of variation (CoV) with CoV = Divide(Standard Deviation, Average Sales) (Deviation and Average measured on a monthly basis)
    I can do the dymamic segmentation separately using the DAX patter, no problem, but I want to be able to present the data in a matrix ABC/XYZ, so I would need to combine the both calculation together, and I am strggling with that.
    I have attached a file to explain the Logic, but in summary below explain what I am trying to achieve:




    Hope it makes sense
     
    Thanks 

    Attachment(s)

    xlsx
    ABCXYZ.xlsx   19 KB 1 version


  • 2.  RE: Need Help Dynamic segmentation ABC/XYZ

    Posted Apr 18, 2022 04:08 AM
    Hi, I was wondering if anyone has any idea to help

    Thanks

    ------------------------------
    christophe cluzel
    RG45 6NN
    ------------------------------