Adding a measure ignores all the filters applied

[Anonymous]

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?

[harshnathani]

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!

[amitchandak]

@Anonymous , is blank can force a left join.

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

[Anonymous]

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.

[sturlaws]

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