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:
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)
Thanks, that seems to have gotten all the measures working, but I am not getting any out put to the visualization, I just keep getting either Blank or 0.00%??
Have you selected two PLUs to compare?
Add a slicer for each of the columns in the calculated table, and select one PLU in each slicer. Does that work?
So I am sure its me doing something wrong here, but still only get blank data. Can you give me a basic rundown on where this data would land in the visualization? I either get an error, blank or a ridiculous number
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:
Sorry, had to jump to another project and took me some time to get back to this. However, as a follow up, I had some relationship errors that was causing my issue, sorted those and running smooth now. Thanks for the help, really appreciate it!