Forum Discussion
MCornish
Responsive Resident
6 years agoSum 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 ...
- 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
MCornish
Responsive Resident
6 years agoAnswered 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