column with REMOVEFILTER doesn't give correct sub-total in a matrix

[Anonymous]

The problem is when I apply the filter I don't get the Complete Sub-Total, I want the sub-total of all the 8 values.

test order num = IF(WC_DOMAIN_MEMBER_LANG_D_STATUS_CODE[Order Status] IN {"Open","Quotation","Appointment","Vehicle Arrived","Maintenance Started","Maintenance Completed","Delivery Completed","Pending Approval"},CALCULATE(COUNT(Fact_W_SRVREQ_F_Service[SR_NUM]),REMOVEFILTERS(Dim_W_DAY_D_Settlement_Date[Settlement Date])),COUNT(Fact_W_SRVREQ_F_Service[SR_NUM]))                                             

                                     

without date filter

The problem is when I apply the filter I don't get the Complete Sub-Total, I want the sub-total of all the 8 values.

[amitchandak]

@Anonymous , I think, it should be a measure like this

test order num = IF(max(WC_DOMAIN_MEMBER_LANG_D_STATUS_CODE[Order Status]) IN {"Open","Quotation","Appointment","Vehicle Arrived","Maintenance Started","Maintenance Completed","Delivery Completed","Pending Approval"},CALCULATE(COUNT(Fact_W_SRVREQ_F_Service[SR_NUM]),REMOVEFILTERS(Dim_W_DAY_D_Settlement_Date[Settlement Date])),COUNT(Fact_W_SRVREQ_F_Service[SR_NUM]))

[Anonymous]

Not working porperly.