month calculation is skewed

[MEGHAMONTY]

Here is my table structure in the Model

MASTERA--> DETAILA

MASTERA-->DETAILB

Both DETAILA & DETAILB tables have data at the invidual date level.

MASTERA only has DETAILA Cust_Name & DETAILB Cust_Name

Here is my Matrix

MASTERA.Cust_Name as Rows

Value is CALCULATE(DIVIDE(DETAILA.COLUMN1,DETAILB.COLUMN2,0), DETAILA.DATE.MONTH, DETAILB.DATEMONTH)

For Columns I am using DATE.MONTH from DETAILA or DETAILB.

The result is taking either sum of the DETAILA.COLUMN1 or DETAILB.COLUMN1 depending on the date i use for columns.

I have tried connecting DETAILA,DETAILB using a calendar table and used month from calendar but again the results are skewed.

I technically want them to divide by month for MASTERA.Cust_Name

[AllisonKennedy]

Are you able to provide some sample data or file?

You need to have a DimDate table which is connected to both Detail A and Detail B, use the DimDate.Month for your columns in the matrix. YOu are right to use MasterA.Cust_Name for Rows.

The measure will need updated as it can't divide one table by the other, so you'll need to add an aggregation in there, such as:

Value= DIVIDE(SUM(DETAILA.COLUMN1),SUM(DETAILB.COLUMN2),0)

You shouldn't need the date filter within the measure, as that will be provided by the context of the matrix.