Forum Discussion
Amounts don't match up
Hello,
I have the following table visualization structure with 3 columns and measures:
| PRODUCT | COLOR | AMOUNT | AMOUNT_ALL | AMOUNT_YELLOW | TOTAL_YELLOW | TOTAL_BLUE |
| A | RED | 537.75 | 628.50 | 24 | 66.75 | |
| A | BLUE | 66.75 | 564.50 | 24 | 66.75 | |
| A | YELLOW | 32 | 61.25 | 32 | 32 | 7.75 |
| 636.50 |
All my measures are off. For example TOTAL_YELLOW should give me 32 for all!
I am pretty new to DAX so I might be missing something:
AMOUNT_YELLOW = SUMX(FILTER(REPORT, REPORT[COLOR] = "YELLOW"), REPORT[AMOUNT])
TOTAL_YELLOW = CALCULATE(REPORT[AMOUNT_YELLOW], ALL(REPORT[COLOR]))