Need help with custom measure creation

[ash757]

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.

[danextian]

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/1447...