Column Subtotal not working

Question

Hi,I have created a Deal_Band Calculated Column, which I am putting it in a Matrix table, but the total is getting repeated.New_Deal_Band = IF('DRID-SolutionMapping'[Net_ASV]&gt;5000000,"5M+",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF('DRID-SolutionMapping'[Net_ASV]&gt;=3000000 &amp;&amp; 'DRID-SolutionMapping'[Net_ASV]&lt;=5000000,"$3M-$5M",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF('DRID-SolutionMapping'[Net_ASV]&gt;=1000000 &amp;&amp; 'DRID-SolutionMapping'[Net_ASV]&lt;3000000,"$1M-$3M",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF('DRID-SolutionMapping'[Net_ASV]&gt;=500000 &amp;&amp; 'DRID-SolutionMapping'[Net_ASV]&lt;1000000,"$500K-1M",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF('DRID-SolutionMapping'[Net_ASV]&gt;=250000 &amp;&amp; 'DRID-SolutionMapping'[Net_ASV]&lt;500000,"$250K-$500K",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF('DRID-SolutionMapping'[Net_ASV]&gt;=100000 &amp;&amp; 'DRID-SolutionMapping'[Net_ASV]&lt;250000,"$100K-$250K",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;IF('DRID-SolutionMapping'[Net_ASV]&lt;100000, "&lt;100K", BLANK())))))))&nbsp;One Case is appearing is all the Deal Bands., like in the below case $15M, getting showing up&nbsp; in all the DealBands. Please advise on this.&nbsp;&nbsp;&nbsp;

lukiz84 · Answer

You sure it's a measure? Doesn't make sense, as in a measure there would be no single value for 'DRID-SolutionMapping[Net_ASV]'

amitkr174 · Answer

Sorry, it's a calculated column.

lukiz84 · Answer

we need more insight in your data model. can you show some tables you use for your matrix and the relationships between?

amitkr174 · Answer

&nbsp;here is the data model connected with DR ID (Many to one)&nbsp;&nbsp;&nbsp;

lukiz84 · Answer

according to your picture, Top_Accounts filters DRID-Solutionmapping, not the other way around (1:m) - so when you add New_Deal_Band from DRID-SolutionMapping to your matrix, it doesn't know how to filter the data, hence showing the same value everywhere.

Forum Discussion

Column Subtotal not working

9 Replies

Related content

Customize subtotal in matrix

Matrix column Subtotal

Column Subtotals Errors

subtotal not work in metrics (value has "if" statement)

Matrix subtotal