Add filters to existing DAX Coding

[1125NEWBIUSER]

Hello,

I am still new to Power BI and DAX Coding. I am working on creating columns to calculate our work in process. We do this by taking the cummulative orders and then subtract cummulative shipped products. Anyway, I have a DAX to do this but need to add two filters to the codes to specify orders and remove a sales type. The code I currently have is:

**bleep** WIP Order Today =

VAR LastVisibleDate =

    MAX ( 'Order/Wip Calculations'[Date] )

VAR FirstVisibleDate =

    MIN ( 'Order/Wip Calculations'[Date] )

VAR LastDateWithSales =

    CALCULATE (

        MAX ( 'Orders/WIP'[Order date] ),

        REMOVEFILTERS ('Orders/WIP')     )

VAR Result =

    IF ( FirstVisibleDate <= LastDateWithSales,

        CALCULATE (    Sum('Orders/WIP'[Quantity]),

            'Order/Wip Calculations'[Date] <= LastVisibleDate )    )

RETURN

    Result

I need to filter the [Quantity] field for the following lines:

'Orders/WIP'[Invoiced] <>"Return" && 'Orders/WIP'[SalesTranType] = 'Standard'

Everytime I try adding I get syntex errors and I am not really sure where I can add that it will work. Do I need to make a variable unit field for the filters and then add to general DAX?

Thanks, Chris

[1125NEWBIUSER]

Thank you, this did the trick!

[amitchandak · Accepted solution]

@1125NEWBIUSER , 1 of the three ways

CALCULATE ( Sum('Orders/WIP'[Quantity]),
'Order/Wip Calculations'[Date] <= LastVisibleDate , 'Orders/WIP'[Invoiced] <>"Return" && 'Orders/WIP'[SalesTranType] = 'Standard')

CALCULATE ( Sum('Orders/WIP'[Quantity]),
'Order/Wip Calculations'[Date] <= LastVisibleDate , filter('Orders/WIP' ,'Orders/WIP'[Invoiced] <>"Return" && 'Orders/WIP'[SalesTranType] = 'Standard') )

CALCULATE (CALCULATE ( Sum('Orders/WIP'[Quantity]),
'Order/Wip Calculations'[Date] <= LastVisibleDate) , filter('Orders/WIP' ,'Orders/WIP'[Invoiced] <>"Return" && 'Orders/WIP'[SalesTranType] = 'Standard') )