Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi!
I'm struggling to come up with a solution on how to filter a table based on values in a column of a variable/calculated table.
So I was thinking of something like this:
Solved! Go to Solution.
Hi @OskariNi ,
Try this:
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @OskariNi ,
Try this:
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please find some dummy table to better describe the question:
Table1 = table that is a variable in measure calculation:
Column1 | Column2 |
A | X |
A | Y |
C | Z |
Table2 = table to be filtered
Column1 | Column2 | Column3 |
A | 1 | 6 |
B | 2 | 7 |
B | 3 | 8 |
C | 4 | 9 |
C | 5 | 10 |
So the desired outcome is to filter Table2 with the condition that Column1 value is in the Column1 of Table1.
can you give an example of what you are asking,as its easier to understand what you are asking for that way.
provide some dummy data or actual data
and then an example of what your expected solution is.
Proud to be a Super User!