Forum Discussion
Measure Column Total All Wrong
Hello
I got the measure total value wrong for one of a column in my Matrix Visual ( Column Name: CALC PRICE), which should be 0.22. Below is the matrix table and measure used to calculate that column
CALC PRICE = SUMPRICE * CALC
SUMPRICE = SUM ('TABLE'[PRICE])
CALC = DIVIDE ([SUMQTY , SUMQTYALL, BLANK())
SUMQTY = SUM('TABLE'[QTY]) & SUMQTYALL = CALCULATE(SUM('TABLE'[QTY],ALLSELECTED('TABLE'))
CAN ANYONE HELP IN HERE TO GET THE CORRECT COLUMN TOTAL!!
| Year | Month Number | Site | SKU | QTY | PRICE | CALC QTY | CALCULATION (CALC QTY) | CALC PRICE | CALCULATION (CALC PRICE) |
| 2020 | 1 | A | 1234 | 17850 | 0.13 | 0.235178 | 17850/75900 | 0.0305731 | 0.235178*0.13 |
| 2020 | 11 | A | 1234 | 17850 | 0.13 | 0.235178 | 17850/75900 | 0.0305731 | 0.235178*0.13 |
| 2020 | 3 | A | 1234 | 17850 | 0.13 | 0.235178 | 17850/75900 | 0.0305731 | 0.235178*0.13 |
| 2020 | 6 | A | 1234 | 3700 | 0.32 | 0.048748 | 3700/75900 | 0.0155995 | 0.048748*0.32 |
| 2020 | 7 | A | 1234 | 18650 | 0.44 | 0.245718 | 18650/75900 | 0.1081159 | 0.245718*0.44 |
| TOTAL | 75900 | 1.15 | 1.15 |
Sample Data:
| Year | Month Number | Site | SKU | QTY | PRICE |
| 2020 | 1 | A | 1234 | 17850 | 0.13 |
| 2020 | 11 | A | 1234 | 17850 | 0.13 |
| 2020 | 3 | A | 1234 | 17850 | 0.13 |
| 2020 | 6 | A | 1234 | 3700 | 0.32 |
| 2020 | 7 | A | 1234 | 18650 | 0.44 |
Thanks,
Nimish
1 Reply
Nimish , you should create a measure like
sumx('TABLE' ,[QTY]*[PRICE])
Multiplication done ate row level
