Incorrect total for column in matrix

Question

Hello,I am getting an incorrect total for my measure. Please see below for the details of my measure.&nbsp;&nbsp;&nbsp;Increase Sale = VAR customers =&nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; ADDCOLUMNS (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DISTINCT ( invoices_details[customer_no] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "@CYSale", [Total Sale],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "@LYSale", [LY Sale],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "@SaleDiff", [Total Sale] - [LY Sale]&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; [@CYSale] &gt; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [@LYSale] &gt; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [@CYSale] &gt; [@LYSale]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; COUNTROWS (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'category',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [@SaleDiff] &gt;= 'category'[category min value]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [@SaleDiff] &lt; 'category'[category max value]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) &gt; 0&nbsp; &nbsp; )&nbsp; &nbsp; RETURN&nbsp; &nbsp; SUMX ( customers, [@SaleDiff] )&nbsp;Thank you in advance for the help.&nbsp;

amitchandak · Answer

Abrar786 , Try two measures like 
&nbsp;
Inc =COUNTROWS (FILTER ('category',[@SaleDiff] &gt;= 'category'[category min value]&amp;&amp; [@SaleDiff] &lt; 'category'[category max value])) Increase Sale =
Sumx(FILTER (ADDCOLUMNS (values ( invoices_details[customer_no] ),"@CYSale", [Total Sale],"@LYSale", [LY Sale],"@SaleDiff", [Total Sale] - [LY Sale]),[@CYSale] &gt; 0&amp;&amp; [@LYSale] &gt; 0&amp;&amp; [@CYSale] &gt; [@LYSale]&amp;&amp; [Inc]&gt; 0),[@SaleDiff])

ahmedx · Answer

write another measure like thisSUMX ( VALUES('table'[category Name]), [Increase Sale]

ashish_mathur · Answer

Hi,
Share the download link of the PBI file.

Forum Discussion

Incorrect total for column in matrix

3 Replies

Related content

Incorrect Column Totals in Matrix showing

Matrix Totals Incorrect

Incorrect Column subtotals in matrix visual

Matrix Column Subtotal showing incorrect amount

Matrix Column Widths