Why default Filter does not work when I have a calculated measure column into the grid?

[aakashdmorya]

I have two tables. Project (ProjectID, ProjectName) and ProjectAssignments (EmployeName, ProjectID, Role).

I have binded all the project into Slicer and converted into the Dropdown. And I have binded all the project assignments to the grid.

So now when I select any project from the dropdown slicer, it filters the Project Assignment table automatically as I have already defined relationship between this two models.

But now I have added a calculated Meaure column to the ProjectAssignmnt model and added that measure column to the Project Assignment grid, and when I do that it stopped the default filters of ProjectAssignment.

So adding calculated Measure column stopped my default filtering option.

Is here any way so that I can come to know how can I overcome this?

[Anonymous]

@aakashdmorya  - What is the behavior? What is the desired behavior? What is the measure expression?

Thanks,

Nathan

[aakashdmorya]

@Anonymous  

I have added few conditional formatting on the dates columns. Please find the image below

When I select a project from slicer, this grid does not filter by selected project, instead, it remove all the conditional formatting. See in image.

M. is my measure column and it has value : 

M = IF(ISBLANK([MeasureCount]),0,[MeasureCount])

where 

MeasureCount is another calculated measure column

let me know if you need any more information

[Anonymous · Accepted solution]

@aakashdmorya  -

What are the conditions for the conditional formatting?

Regarding the measure, does [MeasureCount] work better?

Is it possible to share your pbix?

[aakashdmorya]

Thanks for the reply,

but the report consist of too many data and lots of model into it.

So providing pbix will be not secure for me.

Thing which you can suggest me is, filtering a table visual which have a Measure column in it.

Because if I remove the measure column from the grid, it start working fine.

[Anonymous]

If you have values that are directly filtered by another related table, then it will be filtered automatically. What table are all of the columns coming from? And what is the expression of the other measure?

[aakashdmorya]

Thanks allot @Anonymous  for being with me on this topic. I appreciate your time and curiosity to get it solved.

I figured out that the problem was with my measure. I converted the Measure to Column type and then it worked.