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.
I am trying to replicate these two "pivot" tables here: https://drive.google.com/file/d/1QwfV0DWBc_5B68K45g-fT6Z1DjiXsLHY/view?usp=sharing so that i can do calculations between the two.
Currently my data model does not allow to filter between these two tables. It gives an error when i select columns from both sets. What am i doing wrong?
PBIX:
https://drive.google.com/file/d/186vsjbqclSXB4m5LGwdp3agMQ6-63LDs/view?usp=sharing
Solved! Go to Solution.
hi yours truly from south africa by any chance, i remember all these products 🙂
the problem was your calculated fields cat and one that i removed was creating a circular dependency. I remove and recreated them and set the relationship to active so you can link them see attached
Proud to be a Super User!
use the matrix object rather than the table and place the months on the columns
Proud to be a Super User!
hi yours truly from south africa by any chance, i remember all these products 🙂
the problem was your calculated fields cat and one that i removed was creating a circular dependency. I remove and recreated them and set the relationship to active so you can link them see attached
Proud to be a Super User!
Thank you. How do i get the months to display on top as in these: https://drive.google.com/file/d/1QwfV0DWBc_5B68K45g-fT6Z1DjiXsLHY/view?usp=sharing ?
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 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |