Forum Discussion
Count if earning positive
Hi, I would like to create a new measure (in percentage) regarding what is the overall stability criteria regarding earnings for multiple companies. This is the table that I have: Date Compa...
Check the file now. I think finally got what you wanted :https://www.dropbox.com/s/l5wivh9xwnm1bsi/positiveChanges.pbix?dl=0
amitchandak
Super User
Super UserI did not get your last calculation. But find the solution to get that
https://www.dropbox.com/s/l5wivh9xwnm1bsi/positiveChanges.pbix?dl=0
amitchandakthank you so far, but I still do not get the output that I need. I have the same formulas that you provided but I always get for diff count = 1 and pos count = 1 for each company. This cannot be true. This should give me sth like this:
| Company_Shortcut | pos count | diff count | stability (pos count / diff count) |
| MMM | 1 | 2 | 0.5 |
| AOS | 1 | 2 | 0.5 |
| SO | 2 | 2 | 1 |
| OZK | 2 | 2 | 1 |
- amitchandak
Check the file now. I think finally got what you wanted :https://www.dropbox.com/s/l5wivh9xwnm1bsi/positiveChanges.pbix?dl=0
thanks a lot!!!