How to use expanded matrix to generate dax query that shows correct measure values for hierarchy

[Defenestrator]

I have three tables: Equipment, RBI Components, and TMLs.  There is a one-to-many relationship between equipment table and RBI components table.  There is a one-to-many relationship between equipment table and TML table.  But there is no relationship between RBI Components table and TMLs Table.  There are some equipment IDs with no corresponding component IDs.

I am trying to generate a dax query that shows Equpment ID in column 1, Component ID in Column 2, and Count of TMLs in column 3.  I want the dax query output to show the count of TMLs assocaited with the equipment ID in each row, even for equipment that have no components, and the value should be the count of TMLs for that equipment.   For equipment that have components, I would like to see only one row per component, also with the count of TMLs for that equipment.  I'd like to generate the dax query by copying it from matrix via performance analyzer, and not by hardcoding the dax query. 

The closest I've been able to get to desired behavior is with following measure formula and with row subtotals turned on, except that the resulting dax query has a bunch of extra rows that I don't want: it gives me subtotal even for equipment with components, whereas I want subtotal only for equipment without components.

Test Measure = IF(NOT(ISINSCOPE('RBI Components'[Component Description])),COUNT(TMLs[ENTY_KEY]),CALCULATE(COUNT(TMLs[ENTY_KEY]),CROSSFILTER('RBI Components'[MIV_MIR_HSRBICMP.PRED_ENTY_KEY],Equipment[ENTY_KEY],BOTH)))

Note: 0124 1010-C has TMLs but no components. 

Resulting Dax Query Output:

Other measures that I have tried have caused all the components to appear for every piece of equipment in the matrix.

This seems like it should be simple, but I keep on hitting a brick wall on this.  Grateful for any ideas or solutions.

[lbendlin · Accepted solution]

it gives me subtotal even for equipment with components, whereas I want subtotal only for equipment without components.

Have the measure explicitly return BLANK() for rows you want to suppress.