Forum Discussion

nicolast29's avatar
nicolast29
Helper V
4 years ago
Solved

matrix total

Hi   I use Switch in a matrix, because i love switch đŸ˜€ and it avoid me to use the filters panel   But i don't understand how to calculate my total at the bottom .... Thanks for explaination, th...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure which measure you want to fix, but if you want to fix the [Group I] measure, please try the below.

     

    GROUPE I =
SUMX (
    VALUES ( 'fusion Balances Ts Dos'[Affectation] ),
    CALCULATE (
        SWITCH (
            TRUE (),
            SELECTEDVALUE ( 'fusion Balances Ts Dos'[Affectation] ) = "Achats", [Achats],
            SELECTEDVALUE ( 'fusion Balances Ts Dos'[Affectation] ) = "Autres Prestations", [Autres Prestations],
            SELECTEDVALUE ( 'fusion Balances Ts Dos'[Affectation] ) = "Déplacements, missions et réceptions", [Déplacements, missions et réceptions],
            SELECTEDVALUE ( 'fusion Balances Ts Dos'[Affectation] ) = "Frais postaux et frais de télécommunications", [Frais postaux et frais de télécommunications]
        )
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I am not sure which measure you want to fix, but if you want to fix the [Group I] measure, please try the below.

 

GROUPE I =
SUMX (
    VALUES ( 'fusion Balances Ts Dos'[Affectation] ),
    CALCULATE (
        SWITCH (
            TRUE (),
            SELECTEDVALUE ( 'fusion Balances Ts Dos'[Affectation] ) = "Achats", [Achats],
            SELECTEDVALUE ( 'fusion Balances Ts Dos'[Affectation] ) = "Autres Prestations", [Autres Prestations],
            SELECTEDVALUE ( 'fusion Balances Ts Dos'[Affectation] ) = "Déplacements, missions et réceptions", [Déplacements, missions et réceptions],
            SELECTEDVALUE ( 'fusion Balances Ts Dos'[Affectation] ) = "Frais postaux et frais de télécommunications", [Frais postaux et frais de télécommunications]
        )
    )
)