Summarize Table brining blank fields in the filter table, please help.

[MurVeman]

I am trying to create a Filter table using Summarize function, but the code is bringing blanks as shown on the table below, please help.

BPMNStatusCalculation =
SUMMARIZE(
TestEecution,
TestEecution[BPMN_CC],
"BPMNStatusDesc", CONCATENATEX(VALUES(TestEecution[Overall Status Description]),TestEecution[Overall Status Description],";"),
"MaxFlow", MAXX(TestEecution,TestEecution[Flow]),
"Pass/Fail",CONCATENATEX(VALUES(TestEecution[Pass/Fail/Inprogress]),TestEecution[Pass/Fail/Inprogress],";"))

Screen :- 

[gadielsolis · Accepted solution]

Hello, 

If I understand correctly you should be able to fix this by using filter before the summarize, find belox an example:

FILTER(SUMMARIZE(
TestEecution,
TestEecution[BPMN_CC],
"BPMNStatusDesc", CONCATENATEX(VALUES(TestEecution[Overall Status Description]),TestEecution[Overall Status Description],";"),
"MaxFlow", MAXX(TestEecution,TestEecution[Flow]),
"Pass/Fail",CONCATENATEX(VALUES(TestEecution[Pass/Fail/Inprogress]),TestEecution[Pass/Fail/Inprogress],";")),
NOT(ISBLANK(TestEecution[BPMN_CC])))

[MurVeman]

@gadielsolis,

It worked, thanks a ton!