Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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 ?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
80 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |