Learning a lot on your webinars. Thanks.
I am trying to compute a calculated column in my table Order_Header for Average Sales (not returns) by Client.
My Order_Detail table has [$Sales] which has both positive and negative values. Negative values represent Returns.
The DAX formula below takes all [$Sales] positive and negative. I need to filter for only positive [$Sales] records.
$AvgSlsOnlyNoReturns = calculate(Average(Order_Details[$Sales]), USERELATIONSHIP(Order_Header[ClientID], OrderDetail[ClientID]))
…but do not know how I can eliminate “Zeros” of “Negative Values” in [$Sales] to compute correct average.
Appreciate your help and thanks in advance.