Forum Discussion
jmazzola31
2 years agoFrequent Visitor
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...
some_bih
2 years agoCommunity Champion
Hi jmazzola31 possible solution to count number of customer(if account in Sales Table is customer id) is measure as following
Count Account: DISTINCTCOUNT('Sales Table'[Account #])
Did I answer your question? Kudos appreciated / accept solution!