Data Model relation to get expected solution

[chlimaye]

Hi There,

Please find below screen shot of data model.

We are developing one table viz and requirement is 

we have one column which is derived in DCV table and used a global filter.

and we have measure like previous month volumes which is coming from DVMI using SUbmissionDate master calendar.

when we filter global filter from DCV it will effect the viusal with previous month volumes as blanks and if we remove it it comes back.

what i understand is DCV table doesnt reach out to master calendar SubmissionMonth or DImdate to get previous month calculation.

relation between two table is Market-Brand-SubmissionYearMonth.

please help me to esatblish connection between mastercalendar and DCV table to get previous month data after selection global filter from DCV

[Anonymous]

Hi @chlimaye,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

[Anonymous]

Hi @chlimaye,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[Anonymous]

Hi @chlimaye,

Thank you for reaching out in Microsoft Community Forum.

Thank you @Anonymous  for the helpful response.

As suggested by v-xinruzhu-msft, I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.

[Anonymous · Accepted solution]

Hi @chlimaye 

There is a many-to-many relationship in your data model. It is recommended that you use a bridge table to transform this relationship. You can refer to the following link.

Many-to-many relationship guidance - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

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