Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
@arp2 Updated your PBIX, attached below signature. Your Week to Week relationship is inactive so you need to use USERELATIONSHIP in a measure.
Projected Capacity Measure = CALCULATE(SUM('Table2'[Projected Capacity]), USERELATIONSHIP(Table1[Week], 'Table2'[Week]))
@arp2 Generally this means that there is a missing relationshp in the model.
The dummy PBI file is available at following link.
https://1drv.ms/u/s!Ag_LqrJ6gGmfllbA6ZrdJLdiGkQL?e=WEvQwb
What's happening is, when I add Capacity/Projected Capacity to secondary Y axis, it is summing the value for selected discipline for all weeks in table and showing flat line (summed number) whereas I want weekly number in the chart
@arp2 Right and I'm saying that is generally because there is a missing relationship between 2 tables and thus all of the rows in that second table are in context versus being filtered to the correct rows via the relationship.
@Greg_Deckler Got that! I tried but I am unable to solve it. Can you plz have a look at PBI dummy? https://1drv.ms/u/s!Ag_LqrJ6gGmfllbA6ZrdJLdiGkQL?e=WEvQwb
@arp2 Updated your PBIX, attached below signature. Your Week to Week relationship is inactive so you need to use USERELATIONSHIP in a measure.
Projected Capacity Measure = CALCULATE(SUM('Table2'[Projected Capacity]), USERELATIONSHIP(Table1[Week], 'Table2'[Week]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |