Help with CALCULATE and ALLEXCEPT, and Dimensions

[omartineztr]

I am working with a report that has a Fact table and several dimension tables.

I am trying to calculate a sum of values depending on several filters, so far, I have two "semi" working formulas:

FORMULA 1:

_ccAplied =

CALCULATE(

    SUM(FacAccCustomers[AmountLC]),

        ALLEXCEPT(

        FacAccCustomers,

        FacAccCustomers[Table],

        FacAccCustomers[Company],

        FacAccCustomers[Customer],

        FacAccCustomers[Assignment],

        DimCustomer[Name]

        ),

    FacAccCustomers[DocTypeKey]="MRPAB"

)

This formula works correctly if the table only has columns from the "Fact" table, however, when I add a column from one of the Dim tables for example DimCust[Name], the resulting table shows all the values from the dimension.

FORMULA 2:

_ccAplied_2 =

CALCULATE(

SUMX(

    SUMMARIZE(

        FacAccCustomers,

        FacAccCustomers[Company],

        FacAccCustomers[Customer],

        FacAccCustomers[Assignment],

        "_cc_Net",SUM(FacAccCustomers[AmountLC])),

        [_cc_Net]

),

FacAccCustomers[DocTypeKey]="MRPAB")

This formula somehow shows the total value correct, but at row level the cell is blank.

What am I missing here?
Thank you!

[lbendlin]

See if REMOVEFILTERS is a more appropriate approach.