Filtered calculation

[omergencay]

Hi, I have a problem. I am trying to filter my table with two of its ingredients are "the stock name" and "stock selling profit marge". The Stock name measure is written above "ABC/123" and the stock selling profit ratio measure is written above " 1.2". 

I wanna do a filter like Filter( ratio, ratio >0,00).  But while I am trying to do that, ı couldn't select the "ratio table." What is the problem you think?

Then ı wanna calculate an "average stock selling profit marge" without negative ( <0,00)  and neutral numbers ( 0,00)

[Seward12533]

Can you please share some additional details of your model. If you can't share a sample then at least a picture of the model, some of your measures.

[omergencay]

İncome	Outcome	Average Cost	Discount	profit or loss value	profit/loss ratio
1.186,44	1.020,62	0,51	0	165,82	0,16
614,41	510,31	0,51	0	104,10	0,20
516,95	459,28	0,51	0	57,67	0,13
550,85	510,31	0,51	0	40,54	0,08
1.557,20	1.339,56	0,51	0	217,64	0,16
670,66	760,00	0,51	0	-89,34	-0,12
2.669,49	2.679,13	0,51	0	-9,64	0,00
919,49	790,98	0,51	0	128,51	0,16

[v-huizhn-msft]

Hi @omergencay,

What is your expected result based on your sample table above?

Best Regards,
Angelia