Creating Filter which are in OR condition, 1st filter changes with date. Please help it urgent.

[Anonymous]

Order Status is equal to "A" AND Date is prompted(date filter) OR Order Status is equal to "B", "C", "D". I m creating a matrix with Date filter, I want column B C D give same value even when date is changed and A column give value according to the DATE filter. Please help me.

[lbendlin]

@Anonymous please note that this here is the Microsoft Power BI user forum, not the Oracle BI forum.

[Anonymous]

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