Does the Power BI Matrix table reset all the filter in the calculated dax?

[PeraZo]

Hi Power BI Pros

I am dealing with Power BI Matrix Table and trying to figure out the function of this visual.
Let's say I want to create matrix table showing sum of each month for certain period.

I wrote Dax as

TotalYtd from February =

CALCULATE(

    SUM(Sheet1[Value]),

    DATESBETWEEN(

        'Sheet1'[Date],

        "2/1","4/30"))

This should show the calculation from 2/1-4/30 like this.

But when I relate this table to calendar table as shown below by date,

The output would not show by each month as below.

Each month is showing 8900 which is the addition of 2/1-4/31.

Do you know why this is happening?

I just related the table to the calendar table and do nothing.

I find there are some other mysterious results coming out from Matrix so I just wanted to put this first on table and figure out the function of this Matrix visual which I think is very convenient visual.

Zou

[amitchandak · Accepted solution]

@PeraZo , change join try 1 to many , from date table to another table

[PeraZo]

Thank you sir.

This solved my problem.

Actually both of my table have unique date so I thought it could work with 1 to 1 relationship.

Why does Power BI visualize each month when it is changed to one to many?

Maybe is this because how the matrix visual is made?