topic Re: sumx/summarize affected by filters that not contained in the summarize in DAX Commands and Tips

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

Anonymous — Wed, 01 Jun 2022 08:40:55 GMT

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 ?

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

tamerj1 — Wed, 01 Jun 2022 09:30:38 GMT

Hi Anonymous

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

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

Anonymous — Wed, 01 Jun 2022 09:54:28 GMT

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..

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

tamerj1 — Wed, 01 Jun 2022 10:03:41 GMT

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

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

Anonymous — Wed, 01 Jun 2022 10:06:49 GMT

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

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

tamerj1 — Wed, 01 Jun 2022 11:25:46 GMT

Anonymous
Please try

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

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

Anonymous — Fri, 10 Jun 2022 17:04:24 GMT

it works fine ! thank you so much!!!