Forum Discussion

Jules_0901's avatar
Jules_0901
New Member
1 year ago
Solved

Need %sales



As show in the above images I gave category and Sub Category 
now if i open + I need the %sales based on category and sub Category please help me in getting the % Sales for the above image 

Sales =SUM('Sales Data'[Total Sales])


Thanks
Need Help
  • Khushidesai0109's avatar
    Khushidesai0109
    1 year ago

    Jules_0901 this might help you 




    Sales Percentage Combined =
    IF(
        ISINSCOPE('Inventory'[Sub Category]),
        DIVIDE(
            SUM('Sales Data'[Total Sales]),
            CALCULATE(
                SUM('Sales Data'[Total Sales]),
                ALLEXCEPT('Inventory', 'Inventory'[Category])
            ),
            0
        ),
        DIVIDE(
            SUM('Sales Data'[Total Sales]),
            CALCULATE(
                SUM('Sales Data'[Total Sales]),
                ALL('Inventory'[Category])
            ),
            0
        )
    )



    If yes it Helped you please give me thumbs up and accept the reply as solution 
    Thanks,
    Regards

3 Replies

  • Khushidesai0109's avatar
    Khushidesai0109
    Icon for Skilled Sharer rankSkilled Sharer
    1 year ago

    Can you help me get more details for category and subcategory and data model please

      • Khushidesai0109's avatar
        Khushidesai0109
        Icon for Skilled Sharer rankSkilled Sharer
        1 year ago

        Jules_0901 this might help you 




        Sales Percentage Combined =
        IF(
            ISINSCOPE('Inventory'[Sub Category]),
            DIVIDE(
                SUM('Sales Data'[Total Sales]),
                CALCULATE(
                    SUM('Sales Data'[Total Sales]),
                    ALLEXCEPT('Inventory', 'Inventory'[Category])
                ),
                0
            ),
            DIVIDE(
                SUM('Sales Data'[Total Sales]),
                CALCULATE(
                    SUM('Sales Data'[Total Sales]),
                    ALL('Inventory'[Category])
                ),
                0
            )
        )



        If yes it Helped you please give me thumbs up and accept the reply as solution 
        Thanks,
        Regards