Forum Discussion

Raul's avatar
Raul
Post Patron
8 years ago
Solved

Incorrect total value showing

Hello,

I have this matrix visualization:

 

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):

 

 

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

Thanks a lot!!

 

 

Need Help
  • Raul's avatar
    Raul
    8 years ago

    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. 

    :)

     

4 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Hi Raul

     

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

    • Raul's avatar
      Raul
      Post Patron
      8 years ago

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

       

       

       

       

      • Raul's avatar
        Raul
        Post Patron
        8 years ago

        The relationships between the tables are that:

        All relations with unic cross filter direction.

        Any idea?