Forum Discussion
Count if earning positive
Check the file now. I think finally got what you wanted :https://www.dropbox.com/s/l5wivh9xwnm1bsi/positiveChanges.pbix?dl=0
amitchandakThe overall measure works but not the second one. I get a blank.
The overall output should look like that:
| Company_Shortcut | Stability Earnings |
| MMM | 0.5 |
| AOS | 0.5 |
| SO | 1 |
| OZK | 1 |
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!!!