Forum Discussion
Solved
Create a measure based on filter from another table
Hi, I am lost to find the right measure. The measue should show, based on selected slicers like plant, CommercialID or Date the average of (RMQ Recipes [Wert]) where (Material list [Materialt...
Pillic , there is nothing wrong with formula. you can use average and check.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Oh no.. I think I understand the values now and it seems that all is correct calculated as Amit mentioned. It was my wrong understanding of the calculation, so I added the SUM and the COUNT to follow the "irritation" and that explained it to me...I calculated the wrong column while power bi does calculating the right values.
Thanks for helping me finding the issue 😉
