Percent within Group

Hi MCG,

You need to use the CALCULATE function to find your sales for all products in that category. This should work.

VAR ProductSales = SUM( Sales )

VAR CategorySales =

CALCULATE(

    SUM( Sales ),

    ALL( The table with products in ),

    VALUES( Your category column )

)

RETURN

ProductSales / CategorySales

Effectively the ALL/VALUES combination removes the filters on product but then puts them back on for category.

Let me know if this helps

Kris