View My Drafts
I have the following situation, and I couldn't find a solution to my problem.
I have two tables:
and table B
* The values in the columns from Jan to Dec were input manually just for reference
Which formula or how do I return the sum of the values from column qty on table A to table B based on column state?
I tried this formula below, but I'm getting syntax errors.jan = SUMX(CALCULATETABLE('table A','table A'[month] = "jan",'table A'[state] = LOOKUPVALUE( 'table A'[state], 'table A'[qty], table B[jan])),''table A'[qty])
Hi Raph,Did measure SUM([qty]) not work?Matrix :Column - MonthRows - StateValue - Measure?Regards,