Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
96 | |
80 | |
72 |