Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

using a SUM and ISBLANK includes filtered data

Hey guys,    I have a model with two tables 1 fact (Transactions) and 1 dimension (Seller).  There is a one to many relationship from seller to transactions.  I have a report level filter on the se...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Anonymous,

     

    I have test it with my sample data, we cannot reproduce this issue. Please note that, you need to use seller column in Seller table in your visual and then enable "Show items with no data".
    Measure = SUM(Transacting[Transacting])+0

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Anonymous,

 

I have test it with my sample data, we cannot reproduce this issue. Please note that, you need to use seller column in Seller table in your visual and then enable "Show items with no data".
Measure = SUM(Transacting[Transacting])+0

 

Regards,

Charlie Liao

Anonymous's avatar
Anonymous
Not applicable
9 years ago

You are correct I apologize, I was using the seller in the fact table rather than the seller table.  It is interesting to me though as I would have assumed that whether you are using the seller in the seller table or the fact table I would hav expected the same results but it seems using the seller in the fact table brings back all sellers even though there is a filter on the seller.seller column.