Forum Discussion
Solved
Need help with custom measure creation
Hi, I have a function which calculates the Profit/Loss for the category in sales. But the problem is when most of the Orders are in payout pending bucket, Net Profit is obviously high. Wha...
Hi ash757 ,
Based on the testing, try using the following DAX formula to calculate the profit exclude payout pending.
Net Profit = CALCULATE( SUM(Snapdeal[Payable]) - SUM(Snapdeal[Cost]), FILTER(Snapdeal, Snapdeal[Bucket] <> "Payout Pending" && Snapdeal[Bucket] <> "Cancelled") )The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ash757 ,
Based on the testing, try using the following DAX formula to calculate the profit exclude payout pending.
Net Profit =
CALCULATE(
SUM(Snapdeal[Payable]) - SUM(Snapdeal[Cost]),
FILTER(Snapdeal, Snapdeal[Bucket] <> "Payout Pending" && Snapdeal[Bucket] <> "Cancelled")
)The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This works exactly as I wanted, Thanks!
Also, Can you tell me What's the function of "&&" and how is it different from "&"?