Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Help with Measure Performance

Hi I have a very simple measure to calculate amount using forex rate but it is running slow once I include fields from entities like Contract and Org. The measure is used in a martix. When used in...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    It is would be a good idea to have a date table that filters both Fact and FxRate tables. That would definitely improve the performance. Also note that you DAX would probably generate wrong total.

ppm1's avatar
ppm1
Solution Sage
3 years ago

You should add a Date table to your model (that has a financial period column in it) and relate that to your Reporting Date column in the fact table. You could also likely merge your rate table into your Date table, so you could then do a simple RELATED from the fact table to get the rate for that date.

 

What are the relationships between your tables? I suspect you have a bi-directional relationship in the mix (to the Company table?). Your model should have only 1:M relationships if at all possible. Can you grab the Company code with a RELATED too, to avoid the IF?

 

Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks. I updated the model with relationship between Date and FxRate/ Date & Fact and using related function. It works better now.