topic Re: not filtering the table with the year filter in DAX Commands and Tips

not filtering the table with the year filter

BeginnerBI — Tue, 16 Jan 2024 21:53:52 GMT

I have all the results wonderful when I do not filter but as soon as I filter per year (like in the red header table ) something happens. Please advise

Re: not filtering the table with the year filter

Jihwan_Kim — Wed, 17 Jan 2024 03:49:59 GMT

Hi,

I am not sure how your semantic model looks like, or how your DAX measures look like, but I guess ALL DAX function is used in the DAX measures.

In this case or in this scenario, please try using ALLSELECTED DAX function in the measures.

ALLSELECTED function (DAX) - DAX | Microsoft Learn

Re: not filtering the table with the year filter

Anonymous — Wed, 17 Jan 2024 07:48:22 GMT

Hi BeginnerBI

I've got a general idea of your problem, after you filtered the year with a filter, the Cars and Sold columns got equal.

Based on the rendering you want, the Car column should be a sum of values, but it is affected by a filter that only shows the values for the current year.

Use the all(), allselected(), allexcept(), and removefilter() functions to remove unwanted filtering effects.

Here's a blog about contextual filtering, which you can start with the highlights

Understand the Filter Context and How to Control it

Best Regards,

Zhengdong Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: not filtering the table with the year filter

BeginnerBI — Wed, 17 Jan 2024 13:54:32 GMT

this is the DAX that I am using

Completed% =
DIVIDE(
CALCULATE(
COUNTROWS(FILTER('Customer Contact List', NOT(ISBLANK('Customer Contact List'[DateTime])))),
ALL('Customer Contact List'[DateTime].[Year])
),
CALCULATE(
COUNTROWS('Customer Contact List'),
ALL('Customer Contact List'[DateTime].[Year])
)
)