sumx/summarize affected by filters that not contained in the summarize

[Anonymous]

Hi guys,

i need help with the below Sumx (Summarize) measure:

Summarize contains: table "sheet4", and 3 columns "Year" , "Period" , "Brand cm" .

Then we SUMX with the column "Brand cm".

The result is OK,

but when i apply a filter with a column that IN NOT part of the 3 columns contained in summarize (Year,Period,Brand cm) , then my measure changes !!! any ideas why ?

[tamerj1 · Accepted solution]

Hi @Anonymous 

Of course.
SUMMARIZE is calculated in the current filter context. 
What are you trying to achieve? Can you provide more details?

[Anonymous]

@tamerj1  thank you very much for your reply I really appreciate this!

I have this table:

I want the sum of column "brand cm" to be shown "280" regardless of what customer the user may filter.

So i used the Summarize to group by the unique value per Year,Period and the i summed up.

But when i filter per customer it affects the results..

[tamerj1]

@Anonymous 
Thank you for your repy. But does the expected visual supposed to look like?

[Anonymous]

I want to see "280" and this measure to be the same regardless any filters (i.e customer) that a user may select

[tamerj1 · Accepted solution]

@Anonymous 
Please try

Measure1 =
SUMX (
    CALCULATETABLE (
        DISTINCT ( Sheet4 ),
        ALLEXCEPT ( Sheet4, Sheet4[Year], Sheet4[Period] )
    ),
    Sheet4[brand_cm]
)

[Anonymous]

it works fine ! thank you so much!!!

[tamerj1 · Accepted solution]

Hi @Anonymous 

Of course.
SUMMARIZE is calculated in the current filter context. 
What are you trying to achieve? Can you provide more details?