Many to Many Relationship Not Working?

Hi Anmolgan ,

First of all, if your shared pbix file contain any confidential information or come from real data, we suggest you to delete the shared link as soon as possible.

The Many to Many Relationship is works with the Group Name Column, for example, the following slicer will filter two groups:

Then in the Month Table , thoes two group are releated with following sub table.

So it will show the data of another month because it does not have a relationship between date. we can try to use "Year Month" column from month table as slicer to solve this.

Best regards,

Hi Anmolgan ,

Sorry for late reply, we can create a measure to calculate the total value of Sales Volumn and only use the month column in Month Wise Royalty table as the slicer:

Sales Volume KL Measure =
CALCULATE (
    SUM ( ZSD_MAT_MARGIN_Q003[Sales Volume KL] ),
    FILTER (
        'ZSD_MAT_MARGIN_Q003',
        'ZSD_MAT_MARGIN_Q003'[Calendar Year/Month.Calendar Year/Month Level 01]
            IN SELECTCOLUMNS (
                FILTERS ( 'Month Wise Royalty'[Month/Year] ),
                "MonthYear", UPPER ( [Month/Year] )
            )
    )
)

Best regards,