Forum Discussion

nandvroe's avatar
nandvroe
Frequent Visitor
8 years ago
Solved

Assistance with Dax Formula

I am in need of some assistance with a Dax formula.  I have tried several variations of the formula below:   TotalPending = CALCULATE(SUM(SalesOrderLines[Net amount]), (SalesOrderLines[Line status]...
Need Help
  • nandvroe's avatar
    nandvroe
    8 years ago

    Zubair_Muhammad

     

    Thanks to your help, I was able to get the Dax syntax that I needed.  The formula that seems to be working is:

     

    TotalPending2 =
    CALCULATE (
    SUM ( SalesOrderLines[Net amount] ),
    SalesOrderLines[Line status] <> "Invoiced",
    ALLEXCEPT (SalesOrderLines,SalesOrderLines[Customer]), FILTER ( ALL ( SalesOrderLines[Created date] ), [Created date] <= [LastD] )
    )

     

    Again, I'm finding the All and the AllExcept a little confusing.  Thank you again for your help.

     

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

nandvroe

 

Give this a try...Just removing filters from Customer column using ALL

 

TotalPending =
CALCULATE (
    SUM ( SalesOrderLines[Net amount] ),
    SalesOrderLines[Line status] <> "Invoiced",
    FILTER ( ALL ( SalesOrderLines[Created date] ), [Created date] <= [LastD] ),
    ALL ( SalesOrderLines[Customer] )
)
nandvroe's avatar
nandvroe
Frequent Visitor
8 years ago

Zubair,

Thank you.  However the formula still continues to respond to the Customer filter (slicer).  

 

 

  • nandvroe's avatar
    nandvroe
    Frequent Visitor
    8 years ago

    Zubair_Muhammad

     

    Thanks to your help, I was able to get the Dax syntax that I needed.  The formula that seems to be working is:

     

    TotalPending2 =
    CALCULATE (
    SUM ( SalesOrderLines[Net amount] ),
    SalesOrderLines[Line status] <> "Invoiced",
    ALLEXCEPT (SalesOrderLines,SalesOrderLines[Customer]), FILTER ( ALL ( SalesOrderLines[Created date] ), [Created date] <= [LastD] )
    )

     

    Again, I'm finding the All and the AllExcept a little confusing.  Thank you again for your help.