Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
Solved! Go to 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.
🙂
But if I aply another filter from another table, the total is correct:
The relationships between the tables are that:
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.
🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |