Forum Discussion
Help with measure
Hello,
I have two tables connected by unique code.
in those tables I have a column with another code (not unique, it identifies an area location inside a farm) where certain operations have been done.
I have a line for each operation that has been made in each of those places.
I want to sum the plantation operation areas for the codes that also have reposition operations.
So in conclusion, I want the area that was planted that needed reposition.
I assume I would need to create a measure that for each code it evaluates if there is a line with a resposition, and then it adds all the plantation areas for that code. Not sure how tho
3 Replies
- Greg_DecklerCommunity Champion
Sample data would help tremenously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- AnonymousNot applicable
https://drive.google.com/file/d/1nkhl_i_ZLoecyrn8Lwo1xXccRAUtpUqU/view?usp=sharing
There you can find the report.
Not sure if this is what you meant
- AnonymousNot applicable
Any input would be appreciated.