Forum Discussion
bml123
Post Patron
Post PatronGrand 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...
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] ) ) ) )
PaulDBrown
Community Champion
Community ChampionTry:
Total amount = SUMX(Employee, [Amount])
bml123Post Patron
Post PatronHi PaulDBrown
I have tried your measue, it is not giving any values. It's just blank.
I want the grand total in my matrix to have the correct value.
- PaulDBrown
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] ) ) ) )