Forum Discussion
Accounts Sold Measure Performance
Hello All, I am trying to calculate a measure from the main Sales Table in my report. The Sales Table is the fact table and the model follows a star schema. The Sales Table contains 4.7 million r...
how would I account for the fact I need a table with accounts that have > 0 cases sold?
Hi jmazzola31 assumption for my proposed solution is fact that in your fact table there are already ONLY sold items (customers/accounts key column) sold AND amount of sales is always >0.
I hope this is in your case?
the fact table holds orders of all types. The orders can be 0, negative or positive.
That is why I think I need to create a summarize variable to act is a sub query on the account number and then sum all cases on the account and then check to see if those net cases are greater than 0 or not.