Hi I need a little help to work around getting Totals to show but the issue is with the way measures apply.
Below is my table and the measures for Other 5%
Other 5% = IF([Paint Liquid %]>0.05,[PaintLiq%-5%*Income],0.0) but i need it to show summay
I want to be able to see th summary in the Total instead of $0 and I understand because my measure is calculating every row including the Totals, is there a way I can work around this and have the Totals to be summarised, showing $33360.37 instead of $0.00 as well as 87.34% instead 4.27. SUMX and SUM don't seem to be working as I need a column and I just want to Summarise based on the measure