topic Adding a measure ignores all the filters applied in DAX Commands and Tips

Adding a measure ignores all the filters applied

Anonymous — Mon, 20 Jul 2020 06:05:46 GMT

I have created below table visualization which is filterd by the month selected in the slicer. There are also some visual level filters applied.

I have created this measure which I want to add to the visualization.

Status = IF([MP COUNT]>0,1,

IF (

ISBLANK([IB Template Created])|| ISBLANK([OB Created Date]),

2,3))

When I do so, the table displays all the records. The slicer and visual filters are both ignored. However, the value returned by the measure is accurate and there are no duplicate records. But why are the filters not applying anymore?

Re: Adding a measure ignores all the filters applied

amitchandak — Mon, 20 Jul 2020 06:46:13 GMT

Anonymous , is blank can force a left join.

Can you share sample data and sample output in table format?

Re: Adding a measure ignores all the filters applied

Anonymous — Mon, 20 Jul 2020 07:48:56 GMT

Hi Anonymous ,

Can you elaborate the problem description.

Not very clear as to what you need in the visualization.

Also, share the major details to help yo better.

Regards,
Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

Re: Adding a measure ignores all the filters applied

Anonymous — Mon, 20 Jul 2020 18:30:41 GMT

Thank you for your response. Here is a sample dataset:

The slicer would filter column B to show only the items created in Month of Jan. I would like to add values calculated by the below measure to this visualization as well:

Status = IF([MP COUNT]>0,1,

IF (

ISBLANK([IB Template Created])|| ISBLANK([OB Created Date]),

2,3))

So expected result is:

PID	PID Created	IB Template Created	OB Created Date	MP Count	Status
A	1/6/2020	6/30/2020	12/30/2019	1	1
B	1/17/2020	5/6/2020	1/17/2020		3
D	1/13/2020	2/11/2020			2

But what I get on the visualization is:

PID	PID Created	IB Template Created	OB Created Date	MP Count	Status
A	1/6/2020	6/30/2020	12/30/2019	1	1
B	1/17/2020	5/6/2020	1/17/2020		3
C	2/14/2020	3/18/2020	7/2/2020	2	1
D	1/13/2020	2/11/2020			2
E	3/16/2020	1/18/2020	1/23/2020		3

Eventhough the Status value calculation is correct, all the items are displayed irrespective of the slicer selection.

Re: Adding a measure ignores all the filters applied

sturlaws — Tue, 04 Aug 2020 17:19:26 GMT

Hi Anonymous

i have used your sample data, but I am unable to reproduce your issue.

Also, the dax code you have created will only work as a calculated column, not as a measure.

Could try to recreate your issue in a sample report and share the report?

Cheers,
Sturla