cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bw70316 Member
Member

Matrix Totals Appearing twice in random month?

I am trying to drill down from FY to Month and so on and when  I do I get this error. This is a DL'd PBI that I haven't created the relationships on and do not have access to the source data.

november issue.png

3 REPLIES 3
Community Support Team
Community Support Team

Re: Matrix Totals Appearing twice in random month?

Hi @bw70316

 

You may go to 'Subtotals' under format pane to turn off the column which has 'AAS' values.

2.png

Regards,

Cherie

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bw70316 Member
Member

Re: Matrix Totals Appearing twice in random month?

I figured out it was because all my Budgeted Amounts Load on that date. Causing the issue. I don't know how to get unique values for those expense types if I don't have a proper date however.

Community Support Team
Community Support Team

Re: Matrix Totals Appearing twice in random month?

Hi @bw70316

 

This is due to Power BI being a aggregation tool. You may drill down to Days to get unique values.Power BI also removes duplicate rows from a table by default. The way around this would be to create an index column to provide the uniqueness of rows.

 

Regards,

Cherie

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.