Forum Discussion
Discussion: Alternative DAX Functions for Faster Performance
Personally. I think it's more important to figure out your data model before going into DAX. For example when you are creating VAR in a fact table, your DAX Evaluation will be much slower than if you were doing it on a dimension table since the row count is much lower on the dim. Or any other DAX evaluation for that matter. Reading up on star schema will help you there and I think that's one of the major contributors to more efficient evaluations
Another thing I recently disocvered while working with large datasets is using integers to filter rather than string. For example, let's say my dataset has sales and then customers that are either Gold, Silver or Platinum tier. If I want to filter via CALCULATE, rather than using Customer[Tier]="Platinum" or Customer[Tier]="Gold"... I'll just create a custom integer column on transform data where Silver=1, Gold=2, PLatinum=3... and then Customer[Tierint]=1 and so on.
Personally. I think it's more important to figure out your data model before going into DAX. For example when you are creating VAR in a fact table, your DAX Evaluation will be much slower than if you were doing it on a dimension table since the row count is much lower on the dim. Or any other DAX evaluation for that matter. Reading up on star schema will help you there and I think that's one of the major contributors to more efficient evaluations
Another thing I recently disocvered while working with large datasets is using integers to filter rather than string. For example, let's say my dataset has sales and then customers that are either Gold, Silver or Platinum tier. If I want to filter via CALCULATE, rather than using Customer[Tier]="Platinum" or Customer[Tier]="Gold"... I'll just create a custom integer column on transform data where Silver=1, Gold=2, PLatinum=3... and then Customer[Tierint]=1 and so on.