Need Help on DAX

Hi ssvr,

I made an sample for your reference. Here I created a calculated column using the formula.

Column =
IF (
    [Case No] = "A10",
    "",
    IF (
        [Status] = "Board Review"
            || [Status] = "Approved"
            || [Status] = "Rejected"
            || [Status] = "In Pilot",
        "" & Table1[Received Date],
        ""
    )
)

For more details, please check the pbix as attached.

https://www.dropbox.com/s/5bpc08p47rswabx/Need%20Help%20on%20DAX.pbix?dl=0

Regards,

Frank

Hi ssvr,

I create two measures as below.

Count of project = COUNT(Table1[ProjectNumber])

Measure 2 = SUMX(ALLEXCEPT(Table1,Table1[Resouceinitials]),[Count of project])

For more details, please check the pbix as attached.

https://www.dropbox.com/s/4t5pkbq5cgfdici/DAX.pbix?dl=0

Regards,

Frank

Hi ssvr，

Try to update the formula to this one.

Count of project = COUNTA(Table1[ProjectNumber])

Regards,

Frank