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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.