Single entry from multiple same entry

Anonymous — Tue, 22 Mar 2022 08:55:06 GMT

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.

Re: Single entry from multiple same entry

Anonymous — Fri, 25 Mar 2022 00:59:07 GMT

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

topic Re: Single entry from multiple same entry in Developer

Single entry from multiple same entry

Re: Single entry from multiple same entry