Forum Discussion
Summarize Table brining blank fields in the filter table, please help.
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 :-
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])))
2 Replies
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])))