Forum Discussion
Solved
How can I get dynamic table using filtered data by slicer value on other table?
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' i...
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, "")
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, "")
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!!!