Items with no data, conditional formatting and drill through

Hi Theiren ,

Your issue should be caused by relationship between tables. I think there should be a relationship based on size columns between the data table (in matrix) and a company table (in table visual).

I create a sample to have a test.

Data table:

Company table:

Comment table:

I think you can try this code to achieve your goal.

Measure = 
VAR _List = CALCULATETABLE(VALUES('Table'[Size]),ALLSELECTED('Table'[Size]))
RETURN
IF(MAX(Company[SIZE]) IN _List,CALCULATE(SUM(Commnet[count_of_comment])+0))

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.