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 thi...
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. 

    :)

     

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?

     

     

     

    • Raul's avatar
      Raul
      Post Patron
      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. 

      :)