Forum Discussion
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' 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?
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, "")
3 Replies
- Deku
Super User
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!!!
- lbendlin
What should happen if the CALCULATE returns BLANK() ? Consider using COALESCE().
