Matrix - Total in a measure doesn't sum up

[Anonymous]

I build a matrix where one of the column is a measure that take the biggest number between data coming from 2 differents sources : 

Inscription = SWITCH(
    TRUE(),
    SUM('Prod Asso Inscrites OnLine'[Inscription Prod]) > SUM('GA Asso Inscrites OnLine'[Associations Inscrites]), SUM('Prod Asso Inscrites OnLine'[Inscription Prod]),
    SUM('Prod Asso Inscrites OnLine'[Inscription Prod]) <= SUM('GA Asso Inscrites OnLine'[Associations Inscrites]), SUM('GA Asso Inscrites OnLine'[Associations Inscrites])
)

But as you can see the tota show me 3572 instead of 3813.

[Zubair_Muhammad · Accepted solution]

@Anonymous 

Try this MEASURE which references your original measure

Idea is to sum up the MEASURE "Inscription" for all "Canaux Online" values

iNSCRIPTION2 =
IF (
    HASONEFILTER ( TableName[Canaux Online] ),
    [Inscription],
    SUMX ( VALUES ( TableName[Canaux Online] ), [Inscription] )
)

[Anonymous]

@Zubair_Muhammad 

Thank but how do I add this measure to my matrix as a total ?

[Zubair_Muhammad]

@Anonymous 

Just Add this MEASURE in the MAtrix's Values section.

Replace TableName with your actual TableName

[v-shex-msft]

HI @Anonymous ,

Actually, you not need to use switch function. SWITCH function not suitable to handle summarize records, you can use max function to package these calculations to return the bigger one.

Inscription =
MAX (
    SUM ( 'Prod Asso Inscrites OnLine'[Inscription Prod] ),
    SUM ( 'GA Asso Inscrites OnLine'[Associations Inscrites] )
)

Regards,

Xiaoxin Sheng

[Anonymous]

Thank you @v-shex-msft but I changed the measure ans still have the same result for total.