Filtered calculation

Question

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 · Answer

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 · Answer

İncomeOutcomeAverage CostDiscountprofit or loss valueprofit/loss ratio1.186,441.020,620,510165,820,16614,41510,310,510104,100,20516,95459,280,51057,670,13550,85510,310,51040,540,081.557,201.339,560,510217,640,16670,66760,000,510-89,34-0,122.669,492.679,130,510-9,640,00919,49790,980,510128,510,16

v-huizhn-msft · Answer

Hi&nbsp;omergencay,What is your expected result based on your sample table above?Best Regards,Angelia

Forum Discussion

Filtered calculation

3 Replies

Related content

Calculating with Filters

Calculate Filters

How to search specific word in table filter Calculations

Calculation Group Filters

CALCULATE with multiple filters

İ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