Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SUMX on summarized table

Hi,   I'm quite new in the usage of DAX. So sorry for this maybe basic question. Let's assume I have a fact table fallen 'Sales' which contains following columns: Month, Country,Campaign,Product C...
Need Help
affan's avatar
affan
Icon for Solution Sage rankSolution Sage
7 years ago

Hi Anonymous,

 

Please share some base data and you expected outcome/result sample

 

Regards

Affan

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi affan,

 

thanks a lot for your suggestion. I created a sample. Values are different as in the screenshot as I created a smaller sample out of it (because of these ignore the errors in other measures - not affected by this problem - as well). My target: calculte as an 'Effect Region' on the country row [Delta units] * [Price Diff PY Region - Global], in the Total it should be the SUM of all selected Countries of the column 'Effect Region' (in the sample Czech Republic and Egypt together)

 

Sample SUMX Problem

 

 

Nico 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I am a little further now with the solution. But there is still one problem left which I don't understand. In the following example sample

    I cannot add the measure 'Effect Product' to the existing table. It's running forever til the point I'm getting out of memory (if I'm not filtering it to very granular level before). Logically it's comparable with 'Effect Brand' which works technically without any issue.

     

    Could someone explain me please why I have this problem with this measure and how I could improve it?

     

    Thanks a lot in advance

     

    NicoD82