Duplicate values in table visual

[MadhuKumar]

Hi,

I have created a table visual which shows Date wise, Job wise,takepoint name wise Demand and supply values. The demand comes from takepont table and supply comes from Job table and date comes from Datewise table. I have created  the relationship based on the Id and Job ID between Job and takepoints table. But why i am getting same demad and supply values in a table for each job and takepoints. Is this output correct? If it's wrong how can i make the values correct and show in the table. Also is the relationship created correctly or not? Please suggest how can i male all these correct. Attached screenshots for your reference.

Table Demand and supplyRelationships

[v-kaiyue-msft]

Hi @MadhuKumar ,

Have you already solved the problem? If so, can you share your solution here and mark the correct answer as standard to help other members find it faster? Thank you very much for your co-operation!

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[shafiz_p]

Hi @MadhuKumar  I think there is a relationship problem between Job Table to DatewiseTable. Date from "DatewiseTable" as you have mentioned in the table visual will not filter Job table because of this filter direction. 

It is currently filtering from Job to Datewise but it should be Datewise to Job. Though I don't know hou you have defined your measure.

Try changing the filter direction.


Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[saud968]

If the Id field is indeed the correct field for the relationship, ensure that it is unique in both tables. If not, you may need to create a composite key or use a different field.

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!