Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Devesa_
Frequent Visitor

Keep rows on a Matrix even with no values

Hi
I been trying to search information on how to solve my issue but no luck so far. 
My model looks schematically like this:

image.png

The measure is Duration = Calculate (Sum Inc. [Duration],  Inc. [Major Inc] = "Accepted")

 

My desired outcome is a Matrix like this:

SA_matrix_goal.PNG

 Meaning even though Some services did not logged any duration are still visible in the Matrix. But what I actually get is this:

SA_matrix_outcome.PNG

If under Customer at least one service logged duration time, the matrix shows only that service, otherwise it shows them all.
The "Show items with no data" option is clicked on the Business Services attribute on the rows.

Is there a way to accomplish that?

Thanks!



1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @Devesa_ 

 

vjaneygmsft_0-1643185845394.png

Can you show what's put in the rows and columns of the matrix?

vjaneygmsft_1-1643185973797.png

If this option doesn't work, it's still a problem about measure and relationships.

The sample you provided are not enough to analyze, and the relationship is messy, so it is difficult for me to give advice. Can you provide a more complete sample?


Best Regards,
Community Support Team _ Janey

View solution in original post

1 REPLY 1
v-janeyg-msft
Community Support
Community Support

Hi, @Devesa_ 

 

vjaneygmsft_0-1643185845394.png

Can you show what's put in the rows and columns of the matrix?

vjaneygmsft_1-1643185973797.png

If this option doesn't work, it's still a problem about measure and relationships.

The sample you provided are not enough to analyze, and the relationship is messy, so it is difficult for me to give advice. Can you provide a more complete sample?


Best Regards,
Community Support Team _ Janey

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.