Solved: Single entry from multiple same entry

Anonymous · ‎03-22-2022

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.

Anonymous · ‎03-24-2022

HI @Anonymous,

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

View solution in original post

Anonymous · ‎03-24-2022

HI @Anonymous,

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