Making a blank row visible using an explicit condition

Question

This is my data (the relationship is one-to-many):

I try to make all three rows visible while also having a condition on the 'Year' column. This column is set to 'Don't summarize'. It works fine without any condition on this column, but as soon as I create one, I lose the empty row.

I have enabled the option "Show items with no data". I have also tried "is blank" and "is 0" with no success.

This is the desired result:

arklur · Answer

Get rid of that "both" direction of the relationship, it's an ugly way of being able to filter your "dim" table through the "fact" table. Then create a measure like this, and you will get the desired result:CountRowsTable1 = 
CALCULATE ( 
    COUNTROWS ( Table1 ),
    CROSSFILTER (
        Table2[ID],
        Table1[ID],
        BOTH
    )
)&nbsp;&nbsp;I'm not sure about the "Total", it should be 2 not 3 by your logic.

arklur · Answer

Yes, the relationship should be "single" and 1:N, 99% of the time at least.&nbsp;It's hard to give you the exact answer without knowing the specifics (it doesn't make too much sense for me to include a row in the total that is filtered out in the specific rows), but something like this will work:CountRowsTable1V2 = 
IF ( 
    ISINSCOPE ( Table2[Year] ),
    CALCULATE ( 
        COUNTROWS ( Table1 ),
        CROSSFILTER (
            Table2[ID],
            Table1[ID],
            BOTH
        )
    ),
    COUNTROWS ( Table1 )
)

az38 · Answer

Zyg_D&nbsp;
for me it works ok

Maybe you forgot to mentions something important?
check attached pbix
&nbsp;

farhanahmed · Answer

Drag ID from Table 1Drag Count of ID from Table2Drag Year from Table2&nbsp;At ID right click and enable show items with no data&nbsp;

zyg_d · Answer

Arklur&nbsp;wrote:Get rid of that "both" direction of the relationship, it's an ugly way of being able to filter your "dim" table through the "fact" table. Then create a measure like this, and you will get the desired result:&nbsp;CountRowsTable1 = 
CALCULATE ( 
    COUNTROWS ( Table1 ),
    CROSSFILTER (
        Table2[ID],
        Table1[ID],
        BOTH
    )
)&nbsp;&nbsp;&nbsp;I'm not sure about the "Total", it should be 2 not 3 by your logic.Thanks for the answer.1. So the filter direction generally should go from "dim" table to "fact" table?2. The total should be 3.&nbsp;