cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Incorrect total value showing

Hello,

I have this matrix visualization:

M1.png

 

When I aply a filter from a field of a table (Servei) relationated with de Clients table that is relationated with the FactTable represented in this visualitzation, the total it show wrong (the Fact column is an amount column with the sum agreggation):

 

M2.png

 

Why don't show the correct value (22,80) for the Fact column?

Thanks a lot!!

 

 

1 ACCEPTED SOLUTION

I have found the solution: I have changed the cross filter direction between Serveis and Areas tables to Both and now the value of the column Fact it's correct. 

🙂

 

View solution in original post

4 REPLIES 4
Microsoft
Microsoft

Hi @Raul

 

Because the total line at the bottom is showing the total from line 1 for the X40 grp


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

But if I aply another filter from another table, the total is correct:

M3.png

 

 

 

 

The relationships between the tables are that:

M4.JPG

All relations with unic cross filter direction.

Any idea?

 

 

 

I have found the solution: I have changed the cross filter direction between Serveis and Areas tables to Both and now the value of the column Fact it's correct. 

🙂

 

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors