Better model to improve the performance calculated table/Dax measures

Hi, thanks for sharing the details. Performance issues with calculated tables and complex DAX expressions are common with large datasets. To improve performance, consider using measures instead of calculated columns or tables since measures are calculated on the fly and often perform better. Using variables (VAR) in DAX can help avoid repeated calculations and make formulas easier to read. Avoid complex SUMMARIZE functions in calculated tables and try using GROUPBY or measures for aggregations instead. Apply filters as early as possible to reduce the data processed, such as filtering by Data[Source] = "Invoice". Also, check that relationships are correctly set to avoid ambiguity and many-to-many issues. For very large datasets, consider pre-aggregating data outside Power BI to reduce model complexity. If you want, I can help rewrite your DAX into optimized measures based on your needs. Hope this helps.