Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
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.
İ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 |
Hi @omergencay,
What is your expected result based on your sample table above?
Best Regards,
Angelia
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |