Subtotal issue using summarize and sumx

Question

Hi,My measure using sumx and summarize showing values at market level 0.I wanted to add all the market numbers to get the OU total ,the markets are coming zero and OUs alsoMy OU and Market come from same table.My expected result is :- Correct total at OU level in Measure " Ind Mix Imact on shares PY ". I tries with the correct total one but it showing wrong numbers and ZEROS in market level.&nbsp;Here is the link to the file :-&nbsp;https://www.dropbox.com/s/7oq1viv0f7of033/Total%20error.pbix?dl=0Any help will be appreciated.Thanks in advance.

smpa01 · Answer

souvik900766&nbsp; the rule of thumb is not to use any aggregation inside SUMMARIZE as it is really complex.
https://www.sqlbi.com/articles/all-the-secrets-of-summarize/
&nbsp;
&nbsp;

souvik900766 · Answer

smpa01&nbsp;any way, what to use instead

smpa01 · Answer

souvik900766&nbsp; provide sample data, expected output

vahiddm · Answer

Hi&nbsp;souvik900766&nbsp;SUMX(&lt;table&gt;, &lt;expression&gt;)&nbsp;Change the&nbsp;expression part of your formula to [_1] then check the result.please see this post regarding How to Get Your Question Answered Quickly:https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490The most important parts are:1. Sample data as text, use the table tool in the editing bar2. Expected output from sample data3. Explanation in words of how to get from 1. to 2.4. Relation between your tablesAppreciate your Kudos!!LinkedIn:www.linkedin.com/in/vahid-dm/&nbsp;

souvik900766 · Answer

Hi&nbsp;VahidDM&nbsp;,Here is the file,Kindly help, urgently needed.https://www.dropbox.com/s/7oq1viv0f7of033/Total%20error.pbix?dl=0

Forum Discussion

Subtotal issue using summarize and sumx

10 Replies

Related content

Customize subtotal in matrix

Parameter in summarize

Subtotaling with SUMX and Summarize

Don't Summarize....still summarizes...?

Subtotal issue using summarize and sumx