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 | Company_Shortcut | Earnings |
| 2008-12-31 | MMM | 720347620 |
| 2008-12-31 | AOS | 23740234 |
| 2008-12-31 | SO | 72304726502 |
| 2008-12-31 | OZK | 2346700 |
| 2009-12-31 | MMM | 720357620 |
| 2009-12-31 | AOS | 13740234 |
| 2009-12-31 | SO | 72304756502 |
| 2009-12-31 | OZK | 2349700 |
| 2010-12-31 | MMM | 720307620 |
| 2010-12-31 | AOS | 19740234 |
| 2010-12-31 | SO | 72309056502 |
| 2010-12-31 | OZK | 2399700 |
I have created already 3 measures:
EARNINGS = SUM(Earnings[Earnings])
EARNINGS LY = Calculate([EARNINGS], SAMEPERIODLASTYEAR('Date'[Date]))
Diff Earnings = IF(ISBLANK([EARNINGS LY]),BLANK(),[EARNINGS]-[EARNINGS LY])
Check the file now. I think finally got what you wanted :https://www.dropbox.com/s/l5wivh9xwnm1bsi/positiveChanges.pbix?dl=0
6 Replies
- amitchandak
Super User
This type of calc required context day of the month, calculation like this will help
overall = countX(values(Table[Date]),[Diff Earnings]) count positive overall = sumX(values(Table[Date]),if([Diff Earnings]>0,1,0))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on LinkedinamitchandakThe 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 - amitchandak
I did not get your last calculation. But find the solution to get that
https://www.dropbox.com/s/l5wivh9xwnm1bsi/positiveChanges.pbix?dl=0