Hello,
I’m stumped. I have two datasets: Plant info and Project info. In the Plant dataset, I have a list of companies, plant names, and locations. In the project dataset I have companies, plant names, and project scope for each plant name. Plus much more info. I have tried to merge the scope from Projects into the Plant dataset but it creates a huge file. I have also tried to create a lookup table with plant name and scope and create a relationship back to the Plant dataset. But the arrow flows in the upward direction and not the waterfall effect direction.
Ultimately, I want to show the scope of work when the end-user hovers over the plant name in a map visual on the contact page. I’m just stuck at how to go about this. mental block.
I have attached all the files
Plant Contacts.csv (11.7 MB)
PLANT DATABASE.pbix (28.6 MB)
Plant.csv (8.9 MB)
Project Contacts.csv (998.6 KB)
Project.csv (2.9 MB)
Hi,
IF i understand your problem
The below table you want :
I have attached the pbix containing the solution :
PLANT DATABASE.pbix (28.6 MB)
Let me know incase this does not solve your issue.
Thanks
@Anurag Yes it looks correct, I will open it now and check it out, Thank you for the fast response as this was on a deadline and the last thing I needed to do,
@Anurag can you explain the logic behind the DAX? Why did you choose this route?
Thanks,
Paul
Hi @Paul.Gerber ,
If my provided sol solve your problem then pls mark my reply as solution.
Why i choose this route because of your data model you want value from the many side table and both the table are disconnected one and we have only one direction active there so i first take out company name for that plant name and put that filter on the other table because other conation the company name and after that i just show the required field.
I hope i am making some sense here .
Thanks
1 Like
