ALLEXCEPT issue

[Anonymous]

Hi Community,

I've read a few other posts about people having problem with ALLEXCEPT and I haven't been able to transfer what I've read to a working solution as yet.

I have the below DAX formula:

30_day_test =

CALCULATE(

[30 day Sell Through];

ALLEXCEPT(dim_model;dim_model[id_model];dim_model[Model (brand)])

)

In the below screenshot I have selected a filter that I do not want to affect my measure '30_day_test', hence the number should not match the column '30 Day STR' in the same table.

https://imgur.com/a/7UFhrx2

Is someone able to perhaps provide guidance please, I'm not sure if I am doing something wrong/not understanding the formula correctly?

Thanks in advance,

Phil

[v-lili6-msft]

hi, @Anonymous 

What is the formula of  '30 Day STR', and if you could try to refer to this post:

https://community.powerbi.com/t5/Desktop/Make-measure-ignore-specific-filter/td-p/336870

If not your case, please share your sample pbix file.

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft,

Here are the two formulas to make 30 Day Sell Through

30 day Sell Through =
CALCULATE([New In (#)];fact_published[thirtyd_sold_status] in {1};dim_date[is_past_thirty_days]=FALSE())
/
CALCULATE([New In (#)];fact_published[thirtyd_sold_status] in {1;3};dim_date[is_past_thirty_days]=FALSE())

New In (#) =

CALCULATE(DISTINCTCOUNT(fact_published[id_product]))

is_past_thirty_days is just a calculated column that returns True/False based on Today's date

EDIT: I looked at the post you suggested, the ALL makes sense - and Im trying to do the exact opposite, i.e. allow no filters except on two specific columns. Which is not working.