Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

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

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 =
This should show the calculation from 2/1-4/30 like this.
スクリーンショット 2023-09-25 212153.png
But when I relate this table to calendar table as shown below by date,
スクリーンショット 2023-09-25 212153_2.png
The output would not show by each month as below.
Each month is showing 8900 which is the addition of 2/1-4/31.
スクリーンショット 2023-09-25 212153_3.png
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.



Super User
Super User

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

View solution in original post

Super User
Super User

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

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?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors