Help With SUMIF between different tables (like DAX FUNCTIONS)

[JFSANTUCCI]

Hello everyone,

I'm trying to solve a problem about stock management, where I have the same product addressed in many positions.

I need to make a dinamic table in looker where it shows the product quantity in the main position, in every table line, like the example:

PRODUCT CODE     |      DEPOSIT      |     DEP. POSITION      |      UN. AVAILABLE  |    UN. MAIN POSITION
89898999                  |      FLOOR          |      STF020300A          |       34                          |      34
89898999                  |     RESERVE       |      RES010201A           |       200                        |      34
89898999                  |       LOG               |      STA010302B           |       150                         |      34
89898999                  |       LOG               |      STA010501A            |       200                        |      34

The position in BOLD is the main position where the product is addressed.

I used to do it in Excel with DAX FUNCTIONS using:
SUMX(CALCULATETABLE(TABLE_NAME,TABLE_NAME[DEPOSIT]="FLOOR"),[UN. AVAILABLE])

But I can't use DAX FUNCTIONS in Looker Studios to create this dimension, can someone help me in how can I do this colunm in my table?

[Francesco_V]

You might consider blending 

As an alternative, use windows functions if you are using a custom BigQuery query or  SQL base datasource 

[JFSANTUCCI]

I'm blending tables, but I need one data that is presented in many lines, in just one column of another table.