Forum Discussion
Column Subtotal not working
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]>5000000,"5M+", ...
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.