Percent total denominator help with calculation

[Anonymous]

I'm new to DAX and struggling with returning the total amount denmoniator for a percent calculation using slicers. 

I want the Denomintator to equal 40,170 for all rows in this table. The CE total denominator should = All Brand Families, All Manufacturers, and Draught/Package using the slicers year (2018) and Beer Style (Brown Ale). Filtering by Draught/Package, Brand Family, and Manufactures should not change the total denominator. 

I don't understand why the denominator (total) is not calculating correctly in the grid. 

= divide(sum(FactVwDwEoStarPBIOrders[Case Equivalency]), calculate(sum(FactVwDwEoStarPBIOrders[Case Equivalency]),

ALLEXCEPT(Filter_B_DimVwBrandFamiliesOrders, Filter_B_DimVwBrandFamiliesOrders[BrandFamilyKey]),

ALLEXCEPT(Filter_B_DimVwManufacturersOrders, Filter_B_DimVwManufacturersOrders[ManfKey]),

ALLEXCEPT(FilterVwPackOrders, FilterVwPackOrders[PkgKey])

))

I thought this would mean, get the sum total using slicer year 2018 and slicer Beer Style. This is the calculation I use in the 3rd images Brown Ale Case Equivalency 02 = 40,170. Why doesn't it work as the denominator in the grid and what should I adjust to make it work in the percentage formula?

[satichun]

Hi 

How did you solve this?

[Anonymous]

I have not solved this and i'm still looking for help.

[Anonymous · Accepted solution]

I was able to get the totals by using allexcept filters and removing the joins. 

ce total style items 2 =

CALCULATE

(

SUMX(

CALCULATETABLE(FactVwDwEoStarPBIOrders,

ALLEXCEPT(Filter_B_DimVwBrandFamiliesOrders, Filter_B_DimVwBrandFamiliesOrders[BrandFamilyKey]),

ALLEXCEPT(Filter_B_DimVwManufacturersOrders, Filter_B_DimVwManufacturersOrders[ManfKey]),

ALLEXCEPT(FilterVwPackOrders, FilterVwPackOrders[PkgKey]),

CROSSFILTER(FactVwDwEoStarPBIOrders[ItemKey], DimVwItemsSold[ItemKey], None),

CROSSFILTER(FactVwDwEoStarPBIOrders[BrandKey], Filter_B_DimVwBrands[BrandKey], None)

),

FactVwDwEoStarPBIOrders[Case Equivalency]

)

)

Then I created the % formula:

ce per 2 = divide(sum(FactVwDwEoStarPBIOrders[Case Equivalency]), [ce total style items 2])