Forum Discussion

Post 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

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