Forum Discussion
Many to many relationship mapping
SO[BillingNo] SO[Brand Description] SO[Material] SO[TotalNetCase]
8676137 H 101311 2
8676137 H 101310 2
8676137 H 102607 2
8676137 H 103309 3
as we have 2 possible material group, depending by the total [netcase], for the example, 2+2+2+3=8, which is higher or equal than the Material group table[scalar value] 8(originally have 3 and 8), so it should belong to material group which have higher discount, so how i could i using measure to map correctly
Hi eunji888888,
We kindly request you to submit sample data that clearly illustrates your issue or query in a structured format (not as an image). Please ensure that the data is relevant, devoid of any sensitive information, and directly pertains to the matter at hand. Additionally, kindly provide the expected outcome based on the given example.
Thank you.
7 Replies
Hi,
The question is not so clear and data provided also confusing. Could you please reframe your question ?
Hello eunji888888 ,
as nvprasad mentioned, the question is not clear, if you could explain it.
but what I would advice you when facing a many to many situation is to make the data model as a star schema model.
check the concept of star schema https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Hi eunji888888,
We kindly request you to submit sample data that clearly illustrates your issue or query in a structured format (not as an image). Please ensure that the data is relevant, devoid of any sensitive information, and directly pertains to the matter at hand. Additionally, kindly provide the expected outcome based on the given example.
Thank you.Thankyou, Idrissshatila, for your response.
Hi eunji888888,We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.
If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.
Thank you.Hi eunji888888,
We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.
If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.
Thank you.Hi eunji888888,
We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.
If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.
Thank you.Hi eunji888888,
Kindly confirm if the issue has been resolved. If so, please feel free to share your workaround and mark it as the solution. This will greatly assist other users facing similar challenges to resolve them more efficiently.
In the absence of a response, we shall proceed to close this thread. Should you require further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We will be glad to assist you.Thank you.
