cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aakashdmorya Frequent Visitor
Frequent Visitor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

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

@aakashdmorya  -

What are the conditions for the conditional formatting?

Regarding the measure, does [MeasureCount] work better?

Is it possible to share your pbix?

View solution in original post

6 REPLIES 6
Super User II
Super User II

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

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

Thanks,

Nathan

aakashdmorya Frequent Visitor
Frequent Visitor

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

@natelpeterson  

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

 

Capture.PNG

 

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.

 

Ca1pture.PNG

 

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
Super User II
Super User II

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

@aakashdmorya  -

What are the conditions for the conditional formatting?

Regarding the measure, does [MeasureCount] work better?

Is it possible to share your pbix?

View solution in original post

aakashdmorya Frequent Visitor
Frequent Visitor

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

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.

Super User II
Super User II

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

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 Frequent Visitor
Frequent Visitor

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

Thanks allot @natelpeterson  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.

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors