Forum Discussion

Soldado's avatar
Soldado
Frequent Visitor
3 years ago

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 named "Data Dashboard". I added another columns that is a measure which says the following: 

Final= if(sum(Targets[Target])=0,'Data Dashboard'[Cash Balance],sum(Targets[Target]))
unfortunately, i am not getting the correct sub-total , the sub-total does not show the sum of all the rows.
 
example:

i appreciate your help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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]))) )

  • Soldado's avatar
    Soldado
    Frequent Visitor
    2 years ago

    Hi amitchandak

     

    wooaoo, amazing, it worked perfectly. 

     

     

    I really appreciate your help

     

    You are the best !!!