Forum Discussion

raphazzz's avatar
raphazzz
Icon for Helper I rankHelper I
2 years ago

Help: Matrix Excludes December in Transaction Analysis

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.

 

 

1 Reply