How can I get dynamic table using filtered data by slicer value on other table?

[ishade]

Hi

I have two tables, 'customer' and 'rate'. 

I want fill up 'rate' table with data of filtered 'customer' table, of which procedure is

1. Select a customer by slicer or filter ('10000' is selected by a slicer on above screenshot)

2. Get rate column (90, 85, 83) of filtered '10000' table (left on the screenshot) 

3. Fill those up on rate column of rate table (middle) along with the corresponding categories.

That is, I want to refer the customer as variable (not constant). 

So I tried to use selectedvalue, allselect, lookupvalue, filter...but failed to get the result I want.

It would be highly appreciated if anyone can help me. What shall I do?

[Deku · Accepted solution]

Assume this is what you are looking for

Var rate= 

Calculate(

Max( customer[rate] ),

Treatas( values( rate[category], customer[category])

)

Return 

If( not isblank( rate), rate, "")

[lbendlin]

What should happen if the CALCULATE returns BLANK() ?  Consider using COALESCE().

[ishade]

Dear Deku

I am extremely pleased to report that your answer worked !!!

I modified your statement (RET and IF rows made errors) and got the exact result I want.

Again, I appreciate it very much. Have a nice day!!!