cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Super User

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

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

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

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
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 46 members 1,076 guests
Please welcome our newest community members: