Forum Discussion

MCG's avatar
MCG
Icon for Helper I rankHelper I
6 years ago
Solved

Percent within Group

Hi, i have data set showing sales of product in category: product  category  sales a1             a            10 a2             a             20 b1             b            30 b2             b...
Need Help
  • kriscoupe's avatar
    kriscoupe
    6 years ago

    Awesome MCG  ğŸ˜€! Would you mind marking the answer as a solution so that other can find this in the future and close the thread as solved?

     

    Thanks!

    Kris

AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago

Just going one step further, you could try this as well:

% of Total =
VAR ProductSales =
    CALCULATE ( [TotalSales], ALLSELECTED ( Mcg[Product] ) )
VAR CategorySale =
    CALCULATE ( [TotalSales], ALLSELECTED ( Mcg[Category] ) )
VAR Result =
    IF (
        ISINSCOPE ( Mcg[Product] ),
        DIVIDE ( [TotalSales], ProductSales ),
        IF (
            ISINSCOPE ( Mcg[Category] ),
            DIVIDE ( [TotalSales], CategorySale ),
            DIVIDE ( [TotalSales], CALCULATE ( [TotalSales], ALLSELECTED ( Mcg ) ) )
        )
    )
RETURN
    Result

  • MCG's avatar
    MCG
    Icon for Helper I rankHelper I
    6 years ago

    Thanks

    I will also try your solution

    MCG