cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mbjackson
Frequent Visitor

Matrix Filtered by Distinct Counts Exports No Data

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:

Overlap =
CALCULATE( DISTINCTCOUNT( 'Example Table'[Employee] ) ,
FILTER( 'Example Table' ,
[Σ Hours] <> 0 ) )


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 

SampleSample

2 ACCEPTED SOLUTIONS

Yes, the solution was provied and can be found at the Power BI Link.

View solution in original post

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

Hi @mbjackson ,

 

Looks like this topic has already got the solution?

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Yes, the solution was provied and can be found at the Power BI Link.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors