Help: Matrix Excludes December in Transaction Analysis

[raphazzz]

Hello friends,

I have a table of transactions, and when building a matrix, the calculation omits the month of December.

I started a new file with only the fact table and two dim tables and the relationship between the tables is 1 to * from the dim to fact table.

When I count the rows and set the column with the calendar month, I obtain the count of all transactions for all 12 months.

However, when I use a different measure that counts rows based on a specific condition, it does not include the month of December.

I tried two different approaches to the measures a both are not including december:

A =
VAR A =
CALCULATE (
COUNTROWS ( 'Deferment Data' ),
FILTER ( 'Deferment Data', 'Deferment Data'[Deferment] = "Defer" )
)
VAR B =
CALCULATE (
COUNTROWS ( 'Deferment Data' ),
FILTER ( 'Deferment Data', 'Deferment Data'[Deferment] = "No Defer" )
)
RETURN
DIVIDE ( A, B )

B =
VAR A =
CALCULATE (
COUNTROWS ( 'Deferment Data' ),
'Deferment Data'[Deferment] = "Defer"
)
VAR B =
CALCULATE (
COUNTROWS ( 'Deferment Data' ),
'Deferment Data'[Deferment] = "No Defer"
)
RETURN
DIVIDE ( A, B )

In the database, the month of December is present, and I have verified that the same conditions applied in the measure also include December.

Any suggestions, this is driving me crazy.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.