Forum Discussion
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.
What I want is to exclude Payout Pending rows when calculating the Net Profit by category but it also affects my bar graph which is cumbersome.
Please help!
Thanks in advance.
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.
3 Replies
- danextian
Super User
Hi ash757
Simply based on the information provided, I would create this measure:
CALCULATE ( [net profit], KEEPFILTERS ( 'table'[payout pending] = "no" ) )Otherwise, please provicde a workable sample data (not an image), your expected result from that and the reasoning behind. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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 "&"?
