Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have 3 tables, table 1 contains the file number and fees, table 2 contains file number, working hours, year and company name. Table 3 contains unique file number to connect these two tables. Below are the tables and relationships.
However, when I create the matrix and trying to show bth the working hours and fees of the file number under a particular company, the values "fees" are all the same. I also tried to create a cluster column chart to show the fees and working hours of different companies but the fees are same for all companies.
How can I get different fees under the file number and company? Is there anything I'm missing for the relationship? Thank you!!
Solved! Go to Solution.
Hi @Apeyy ,
Just change the relationship from "single" to "both".
Best Regards,
Jay
Hi @Apeyy ,
Just change the relationship from "single" to "both".
Best Regards,
Jay
@Apeyy , because the company is not common between two tables. only one table has that.
That is why is it not working.
Also common table only work if that is context
You can try like
Sumx(values(Table3[File]), calculate(sum(Table1[Fee])))
But I doubt this will make are the difference.
Also, prefer to share data in text format.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |