Count of projects with single task name or multiple based on condition

[Hkam]

I need help with @dax 

I need count of unique projects based on condition.

DAX1:CALCULATE count of projects which has only one task and that should be "support".

DAX2:calculate count of projects which has only "support" and "migration" tasks together 

Please find the image for reference

 expected output for dax1: 2 (Ws3,Ws4)

Expected output for DAX2:2(Ws2,Ws5

)

Thanks in advance

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below measures and the attached pbix file.

Dax one measure: = 
VAR _newtable =
    SUMMARIZE (
        FILTER (
            ADDCOLUMNS (
                VALUES ( Data[Project] ),
                "@taskcount", CALCULATE ( COUNTROWS ( Data ) )
            ),
            [@taskcount] = 1
        ),
        Data[Project]
    )
RETURN
    COUNTROWS (
        FILTER ( Data, Data[Task] = "Support" && Data[Project] IN _newtable )
    )

Dax two measure: = 
VAR _newtable =
    SUMMARIZE (
        FILTER (
            ADDCOLUMNS (
                VALUES ( Data[Project] ),
                "@taskcount", CALCULATE ( COUNTROWS ( Data ) )
            ),
            [@taskcount] = 2
        ),
        Data[Project]
    )
RETURN
    COUNTROWS (
       SUMMARIZE( FILTER ( Data, Data[Task] in {"Support", "migration"} && Data[Project] IN _newtable ), Data[Project])
    )