Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

dax for lastnonblank with filters

I am trying to filter the measure count(...) with an expression from Orders table with condition Final=1.I am not able to include that anywere in the measure.Tried a couple of ways but no luck.Ps help

 

TotalReceiving:=calculate(COUNT('Orders'[OrderID]),LASTNONBLANK('Date'[Date],CALCULATE(COUNT('Orders'OrderID]))))

I need to include another filter condition here like:

'Orders'[Final]=1