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.
Greetings,
I have attached a simplified PBIX which demonstrates an issue I have run into. The goal is to have a matrix which lists products worked on by more than one employee, "overlap". I was able to achieve this in the blue matrix (closest to the bottom). In order to achieve this I used this measure:
and filtered the matrix on the measure having a value greater than 1.
The issue is when I go to export the blue matrix to excel, the export contains no data. This issue is encountered in both desktop and service. I believe the root of the issue is that the filter is only applied to the rows (products) in the matrix but is applied to both the rows and columns (employees) upon export. With each employee having a DISTINCTCOUNT( employee) of 1 they are all excluded!
I also tried to create a calculated column but that removed the context of the month slicer.
Any help or direction would be greatly appreciated as I have spent nearly half a day working this problem.
Thanks
Malcolm
PBIX Located Here
Solved! Go to Solution.
Yes, the solution was provied and can be found at the Power BI Link.
Hi @Anonymous ,
Looks like this topic has already got the solution?
Best Regards,
Jay
Yes, the solution was provied and can be found at the Power BI Link.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |