Forum Discussion
I_LOVE_POWER_BI
Helper III
Helper IIIMeasure 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.
I_LOVE_POWER_BIHelper III
Helper IIIThanks! 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:
I_LOVE_POWER_BIHelper III
Helper IIIUsing two SUMX actually solved the problem.