Forum Discussion
Sum issue
The data I have can only be delivered in that format from the system. There are about 50 other fields in addition to the ones notated, but the ones I put down are the only ones I care about. I have a table visual on another page and this is the end goal:
| Empl ID | Job Title | Salary | # Shares | Value (@ $18/share) | Total Comp | Group |
| 100000 | VP | $ 400,000 | 334 | $ 6,012 | $ 406,012 | Engineering |
| 200000 | Manager | $ 150,000 | 458 | $ 8,244 | $ 158,244 | Communications |
Shares being the # of shares from the data notated in previous post with vesting dates greater than Nov 1, 2017.
So you see, I can't do it like that because I need to put it in a table that is not date filtered which is why I need to get this in a measure format...
Not everyone will have stocks and there are times where I may need to kick out Vest 1 and Vest 2, only to include Vest 3 or change the date parameters in a measure...
sorry buddy, i'm not very clear what i proposed why that will not work. i'm surely missing something here. i hope someone else can help.
Well I'm more than happy to help but still not very clear what is not working and what the challenge is. may be share your pbix file with some sample data, that might help.
I know, but I need it as a measure as I am not doing pivots or using it as a visual. It needs to be used as a field in the main Table visual, not as its own. I can use your method if I needed to do it as its own visual as you have it laid out, but not in this case.
not sure why you stuck it that you need it as measure. anyhow just added it as a "Total Shares" measure and updated pbix.
Sounds good.
Good luck!