how to ignore report filter for text in a table

[Anonymous]

I have a table that consists of Project id and employee hours . Report filter for all pages is Project status that needs to be ingnored. 

I created a measure for employee hours ( calculate([employee hours],all(job[project status])) ) ingnoring the project status but i have problem with Project id column that is text. 

How to ignore page filter for the first column ? when i create measure for project filed that is text ? When i create measure with min / max it will just give me one row instead of whole table.

[Anonymous]

Data sample : 

Project id	Employee hours
1010 abcd	20
1011 edgh	40
1012 abcd	20
1013 edgh	50
1014 abcd	10
1015 edgh	20

Report filter (all pages filter) set to Project status = prod

Measure for employee hours ALL(project status) dont work because Projects that are not in "prod" are being filtered out

How to ignore report filter for Project id so it will show all reports in the table ?  

[v-lili6-msft · Accepted solution]

hi @Anonymous 

For your requirement, it could not be achieved in power bi for now.

You must know that measure is a dynamic aggregate value that based on the row context.

Since [Project id] is a dim field, you could not use measure for it.

You could only set visual filter for each visual in the report except the visual which [Project id] in it.

Regards,

Lin