Data not showing in Matrix and totals are not blanks!!

[hatahetahmad]

Hello BI Community,

I have a data model, all working just fine, BUT after refreshing the data as normal, two of the companies disappeared.

I have checked the source files, nothing changed, since the files are just an export from QuickBooks.

Then I exported my Matrix to CSV to see if these companies have numbers, AND they are empty!! Why is that happening!!

I tested the measure I'm using individually and all giving me numbers only when I filter to the specific company, when all companies selected only the two in the picture shows.

Please, Any Explanation?

P.S: My data are the same structure and I didn't change anything at all JUST refresh, and this happened.

[hatahetahmad · Accepted solution]

I found a broken link in of my table causing the blank results, FINALLY SOLVED.

Many thanks to all views.