Filtered rows

[Anonymous]

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: 

Startdate (filter) =

SWITCH(

    TRUE(),

     ISFILTERED('Productivity tbl'[Project taak]), BLANK(),

     ISFILTERED('Project tbl'[Startdatum]), BLANK(),

     CALCULATE(

        MIN('Project tbl'[Startdatum])

       )

)

Unfortunately, it returns also rows with dates for Projects the employee didn't work on. It is just the startdate of the project (another employee was signed on to). 
How can these rows be filterd, so that a more clean overview is presented (in this case, only the project Cadamusque for Albert?).

The names (and projects) are fictional.

   

[Anonymous]

@rajendraongole1 , perfect! Exactly I was looking for 🙂

[rajendraongole1 · Accepted 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!!