Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

SUMX between two tables

Hi All,   I have two fact tables with different granularities. One with sales forecast per market per city, and one with the share of sales forecast per market per product grouping. The idea behind...
Need Help
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

You could refer to my sample for details. If this si not waht you want, please correct me and inform me more details(such as your expected output).

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Zoe!

     

    Thanks a lot for looking into this! Indeed with your solution the share of sales forecast looks fine, too.

    I know my post was quite long but my question actually was: why does my seemingly wrong solution show the correct '

    SUMX test - Sales forecast'? 
    Again, the formula for my SUMX sales forecast is:  SUMX('market and city level data', [Sales Forecast] * [Share of sales forecast]). 
    So for example in the top row in the table on the left (my solution), multiplying EUR 15 by 0,95 should definitely not result in EUR 4,50, but it still does somehow.
     
    Just to double clarify, I get the correct results in my solution, and I am just trying to understand why.
     
    Thanks a lot again,
    Csaba