Forum Discussion
How do I create a measure that references two different tables
- Anonymous7 years ago
Everything I've had to do thus far for things like this was to get the tables merged into a singular query. Manipulate the date info, so that it's supportive of an employee record etc. I haven't been able to have like what you wanted (and I did too) which was to have multiple different queries and have a slicer affect them all. The way I solved this was to create modular queries that worked as autonomous tables, and then a set of queries that built joins upon those "atomic level" queries. Then I could get the visuals to all filter nicely.
hope it helps.
Hi Anonymous ,
Can you please post a dummy file or the sample data and the expected output? Then we can help you as soon as possible.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Xue
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.