Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Matrix - Total in a measure doesn't sum up

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.

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank you Anonymous but I changed the measure ans still have the same result for total.

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Zubair_Muhammad 

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

       

       

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Anonymous 

         

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

        Replace TableName with your actual TableName