Row-wise total base on select date

[ABC11]

Hi All,

I would like to do rowwise total base on selected date

LINE_Total = sumx(Report,

Report[APPR_LINE]+

Report[ATTEST_LINE]+

Report[COMP_LINE]+

Report[POSTED_LINE]+

Report[REJECT_LINE]+

Report[RESUBMIT_LINE]+

Report[SUBMIT_LINE]+

Report[WAPPR_LINE])

This yellow color row wise line total is incorrect.

Thanks

[lbendlin]

LINE_Total = 
Report[APPR_LINE]+
Report[ATTEST_LINE]+
Report[COMP_LINE]+
Report[POSTED_LINE]+
Report[REJECT_LINE]+
Report[RESUBMIT_LINE]+
Report[SUBMIT_LINE]+
Report[WAPPR_LINE]

[ABC11]

Thanks for your time. But look like it error out.

[lbendlin]

This needs to be a calculated column, not a measure.

[ABC11 · Accepted solution]

Thank you for your time.

I did find sloution other way