All four growth percentages are the time killers.
So as an example
Qty Growth %=
VAR Diff = [Qty] - [Qty Prior]
VAR Result = DIVIDE(Diff,[Qty Prior],BLANK())
RETURN
Result
[QTY] and [QTY Prior] both use switch statements to calculate based on the period selected
To me in my ignorance I dont see an issue in the growth %
Data Model size is 250 MB
From DAX Studio
One fact Table (Data = 349,871,608) - Cardinality 15 million
23 Dimension Tables
Sales table (Fact) is around 80% of the model size.
No local date tables
2 largets dimensions by data size are 4-5% of the DB
One dimension with in excess of 2M rows.
All joins are 1:M
Thanks
E