Forum Discussion

MCornish's avatar
MCornish
Icon for Responsive Resident rankResponsive Resident
6 years ago
Solved

Sum is excluding rows

Ok, tricky one this time.   I have a product table (roughly 13K products). I have another table that lists our promotions. In between these table sits a table that contains the promotion and every ...
  • MCornish's avatar
    6 years ago

    Answered my own question.

     

    Created a "Count Products" measure that just does a count from the bridge table and used that as a filter on the table where it must be greater than 0.

     

    Also left the "Show items with no data" on