Forum Discussion
Troubles in relationship between 2 queries
Anonymous
That's probably because there is more than one entry with the same Project ID inTable22. That should have been specified earlier. Let's do the sum then. And since you talk about using a slicer, let's do all this in a table visual; the slicer will no affect a calculated column.
1. Place Table1[Phase] and Table1[Heures Prévues] in a table visual. Make sure both are set to "Don't Summarize"
2. Create this measure and place it in the visual:
Measure Total Hours = VARcurrentPhasee_ = SELECTEDVALUEE ( Table1[Phase] ) RETURN CALCULATE ( SUM (Table22[Total Hours] ), Table22[Phasedee projet] =currentPhasee_ ) + 03. See it all at work in the attached file.
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Community SupportHi, Anonymous
According to your requirement, you can try Merge query in power query editor, you can follow my steps:
- Open power query editor, click this:
- Set this query like this:
- Click ok, go to the merged table, expand table, like this:
- Then you can get a table like this:
You can download my test pbix file here
And you can get what you want.
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.