Forum Discussion

TTKellogg's avatar
TTKellogg
New Member
5 years ago
Solved

Analyze Data based on Multiple Criteria

Hi.  I really need some help!  I have a list with multiple projects in it (Proj_Short_Name).  Within each project there are task_code.  The task_code are unique within a project but are reused across...
Need Help
Tutorial Requests
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Taffalaffa ,

     

    Use the following two measures:

     

     

    Pred Dangler = 
VAR A = { "Finish to Start", "Start to Start" }
VAR B =
    CALCULATETABLE (
        VALUES ( 'Starting Data'[PRED_REL_TYPE]),
        FILTER (
           ALL( 'Starting Data'),
            'Starting Data'[PROJ_SHORT_NAME] = EARLIER( 'Starting Data'[PROJ_SHORT_NAME] )
                && 'Starting Data'[TASK_CODE] = EARLIER ( 'Starting Data'[TASK_CODE] )
        )
    )
RETURN
    IF ( COUNTROWS ( EXCEPT ( A, B ) ) > 0, 0, 1 )


Succ Dangler = 
VAR A = { "Finish to Start", "Finish to Finish" }
VAR B =
    CALCULATETABLE (
        VALUES ( 'Starting Data'[PRED_REL_TYPE] ),
        FILTER (
            ALL('Starting Data'),
            'Starting Data'[PROJ_SHORT_NAME] = EARLIER ( 'Starting Data'[PROJ_SHORT_NAME] )
                && 'Starting Data'[TASK_CODE] = EARLIER ( 'Starting Data'[Task_Code] )
        )
    )
RETURN
    IF ( COUNTROWS ( EXCEPT ( A, B ) ) > 0, 0, 1 )

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Taffalaffa ,

 

Use the following two measures:

 

 

Pred Dangler = 
VAR A = { "Finish to Start", "Start to Start" }
VAR B =
    CALCULATETABLE (
        VALUES ( 'Starting Data'[PRED_REL_TYPE]),
        FILTER (
           ALL( 'Starting Data'),
            'Starting Data'[PROJ_SHORT_NAME] = EARLIER( 'Starting Data'[PROJ_SHORT_NAME] )
                && 'Starting Data'[TASK_CODE] = EARLIER ( 'Starting Data'[TASK_CODE] )
        )
    )
RETURN
    IF ( COUNTROWS ( EXCEPT ( A, B ) ) > 0, 0, 1 )


Succ Dangler = 
VAR A = { "Finish to Start", "Finish to Finish" }
VAR B =
    CALCULATETABLE (
        VALUES ( 'Starting Data'[PRED_REL_TYPE] ),
        FILTER (
            ALL('Starting Data'),
            'Starting Data'[PROJ_SHORT_NAME] = EARLIER ( 'Starting Data'[PROJ_SHORT_NAME] )
                && 'Starting Data'[TASK_CODE] = EARLIER ( 'Starting Data'[Task_Code] )
        )
    )
RETURN
    IF ( COUNTROWS ( EXCEPT ( A, B ) ) > 0, 0, 1 )

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Taffalaffa's avatar
Taffalaffa
Helper I
5 years ago

This is fantastic! Thank you so much for your help!