Forum Discussion
Sub-total incorrect
Hi I have an issue with the sub-totals in a matrix table. The table has two columns, one column (Target) comes from a table named "Targets", the other column (Cash Balance) comes from a table nam...
Soldado ,You need to use a column in visual
Sumx(Summarize(Targets, Dim[Sub Region], DIm[REgion] ) , calculate( if(sum(Targets[Target])=0,'Data Dashboard'[Cash Balance],sum(Targets[Target]))) )