Forum Discussion
Why default Filter does not work when I have a calculated measure column into the grid?
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?
What are the conditions for the conditional formatting?
Regarding the measure, does [MeasureCount] work better?
Is it possible to share your pbix?
6 Replies
aakashdmorya - What is the behavior? What is the desired behavior? What is the measure expression?
Thanks,
Nathan
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])whereMeasureCount is another calculated measure columnlet me know if you need any more informationWhat are the conditions for the conditional formatting?
Regarding the measure, does [MeasureCount] work better?
Is it possible to share your pbix?
