Table is not filtering as expected

[aboodhamwi]

Hi,

I have one report, the data is from the CDS, the structure of the data is, I have Contract table, under that table there is Agreements table, the contract is the parent, now In the report, there is one page for contracts details, as a table, and I made another page where it will show the Agreements, I made the Drill-through, it's working in a way, but not fully, this is the table of contracts

and once I will do drill through, it should only show me the agreements of that contract, now for some reason, the result is, the agreements of that contract, an empty line, then all agreements, I want only the agreements of that contract to show and not the rest 

[amitchandak]

@aboodhamwi , do you have any measure with +0 .

Or you checked this option by mistake - Show item with No data

[aboodhamwi]

Hi @amitchandak ,

Yes, I do have measure, is this the problem?

[aboodhamwi · Accepted solution]

Thanks @amitchandak for pointing me to the correct place, the problem was, in one my measure, i had an If, and that was the cause