Forum Discussion

bml123's avatar
bml123
Icon for Post Patron rankPost Patron
4 years ago
Solved

Grand Total is not correct

Hi,   I have a matrix like this where amount is a measure. I am getting grand total incorrect as you can see.  There is some calculation in amount measure for Others.  It's ignoring the value for o...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Which table is the Employee field in the visual coming from?

    If it's the Employee table try:

    AMOUNT =
SUMX (
    'Employee',
    CALCULATE (
        SWITCH (
            MAX ( Employee[Employee] ),
            "Others", DIVIDE ( 150, 10 ),
            DIVIDE ( [Target], [Num_weeks] )
        )
    )
)



  • bml123's avatar
    bml123
    4 years ago

    Hi PaulDBrown ,

     

    It worked. Thank you so much for the solution. 

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Which table is the Employee field in the visual coming from?

If it's the Employee table try:

AMOUNT =
SUMX (
    'Employee',
    CALCULATE (
        SWITCH (
            MAX ( Employee[Employee] ),
            "Others", DIVIDE ( 150, 10 ),
            DIVIDE ( [Target], [Num_weeks] )
        )
    )
)



bml123's avatar
bml123
Icon for Post Patron rankPost Patron
4 years ago

Hi PaulDBrown ,

 

It worked. Thank you so much for the solution.