Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hey everyone,
I have a Project tbl and a Productivity tbl. There are connected based on ProjectID, with a 1-* relationship from Project to Productivity. Furthermore, I have a Employee tbl, which is connected with the Producitivity tbl on EmployeeID. An Employee can have several one or more projects, so the the relationship is 1-*.
I have a matrix table with Employee, Project and Project category. I have informtion about the startdate of projects, but not for its category. Therefore, I want to show nothing, hence blanks, for these rows. The measure is as follows:
Solved! Go to Solution.
Hi @Anonymous -can you check the below measure to displays blank for rows where the project category does not have a start date
Startdate (filter) =
VAR IsFilteredByProject = ISFILTERED('Productivity tbl'[Project taak])
VAR IsFilteredByStartDate = ISFILTERED('Project tbl'[Startdatum])
RETURN
SWITCH(
TRUE(),
IsFilteredByProject, BLANK(),
IsFilteredByStartDate, BLANK(),
CALCULATE(
MIN('Project tbl'[Startdatum]),
'Productivity tbl',
'Employee tbl'
)
)
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
Hi @Anonymous -can you check the below measure to displays blank for rows where the project category does not have a start date
Startdate (filter) =
VAR IsFilteredByProject = ISFILTERED('Productivity tbl'[Project taak])
VAR IsFilteredByStartDate = ISFILTERED('Project tbl'[Startdatum])
RETURN
SWITCH(
TRUE(),
IsFilteredByProject, BLANK(),
IsFilteredByStartDate, BLANK(),
CALCULATE(
MIN('Project tbl'[Startdatum]),
'Productivity tbl',
'Employee tbl'
)
)
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |