Amounts don't match up

[Anonymous]

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

[Anonymous]

Hi @Anonymous ,

Glad to hear that your issue has been resolved. Please mark your answer as a solution, it will help more people with the same problem.

Best Regards,

Neeko Tang

[Anonymous · Accepted solution]

It seems that using ALLSELECTED instead of ALL works!

😀