Single entry from multiple same entry

[MR007]

Hi All,

as per below attachment i need only those line items "Sum value (testing2)" where "dc" filed have "H&S"(both) except this if we have only "H" then its value shoud be "0"...

please help me to resolve this issue.

Thanks in advance.

[v-shex-msft · Accepted solution]

HI @MR007,

You can try to use the following measure formula if it was suitable for your requirement:

formula =
VAR currAssignment =
    VALUES ( Table[Assignment] )
VAR summary =
    SUMMARIZE (
        FILTER (
            ALLSELECTED ( Table ),
            [DC]
                IN { "H", "S" }
                && [Assignment] IN currAssignment
        ),
        [Assignment],
        "c_DC", COUNT ( Table[DC] ),
        "s_Test2", SUM ( Table[Test2] )
    )
RETURN
    SUMX ( FILTER ( summary, [c_DC] = 2 ), [s_Test2] )

Regards,

Xiaoxin Sheng