Forum Discussion
Calculate Yield
It would help to see the calculations as you have them and the visual you're trying to produce.
That said, here is how I did it - 2 slicer visuals, and 1 card visual:
Got the first part working, by creat a calculation do you mean create a calculated coulumn in my new table or a measure?
DIROPS - 2nd part is a measure.
Also, the [Weight Calculation] should be a separate Measure, called something like [Total Weight].
Firstly, thank you again for your continued guidance, I need all the help I can get! Hopefully last few questions:
1. In the second part, I dont understand what this is referencing vs my data, in other words I dont know what to point to here
FILTER(Store, Store[Store Country]
2. The [Weight Calculation], should this just be a totalization of the Net Weight?
1. Ah! Sorry, I tested with my tables, but missed removing that part. It should be filtering the PLU:
FILTER(<PLU Table>, <PLU Table>[<PLU Column>]
2. Yes, create a measure like this: Total Weight = SUM(Weight)