Forum Discussion
Solved
Measure with different granularities
Dear Community, I have a problem using a fake example to try to get to my answer. I create a measure , which is a multiplication between ingredient and price (two fact tables) via a material dime...
Using two SUMX actually solved the problem.
Thanks! It technically works, however you have to imagine, that the Prices table includes many prices for the different material classes. But normally I want the exact material price to be used, only if the recipe table uses a material group the average shall be used. I updated the screenshot accordingly:
Goal is to use the green marked prices:
Using two SUMX actually solved the problem.