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...
Hi jmazzola31 optimization is not easy, based what you wrote please try following measure as test and if this is not ok for you please check article on link for optimization (apply on your case)
https://www.sqlbi.com/articles/differences-between-groupby-and-summarize/
Count Account Measure=
CALCULATE(
DISTINCTCOUNT('Sales Table'[Account #]),
'Sales Table'[Cases Column]>0
)