How Set Analysis works when measure field exists in different table and Dimension value is NULL

[Digvijay_Singh]

Hi,

I am trying to understand why set analysis drops some rows when chart dimension value is null and measure field exists in different than chart dimension field.

I have attached sample app, very similar to what we have in production app. The main question is, why left chart shows count 2 against null dimension but right one shows 1 against null dimension.

I observed if I replace set analysis expression with IF statement, both chart shows 2 against null dimension value.

@hic 

@swuehl 

@stevedark 

@rwunderlich 

@jagan 

@Gysbert_Wassenaar 

@sunny_talwar 

Any help will be highly appreciated.

Thanks,

DJ

[Digvijay_Singh]

When I drop 'Key' column from the table, It drops the middle record. Strange,  Even 'Key' removal wasn't making duplicate records situations in the table.