Forum Discussion

tyleharris's avatar
tyleharris
Frequent Visitor
6 years ago

Help Optimizing DAX Measures

Good afternoon all,   I'm working on a project that requires me to calculate the yearly totals of sales amount, sales quantity, 9L cases, and total transactions for a long list of customers IDs. Ho...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

What's your data model look like?  Happen to have a data table?  Looks like you do not as you have this :

..
FILTER (
            ALL ( 'Sales Transactions'[Transaction Date] ),

I'm assuming this is your Fact table. You really dont want to filter (i.e. iterate) a fact table because you will see a performance hit. 

 

Take a look at this post where someone had the same issue

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Is-there-a-faster-Average/m-p/779453#M4079

 

  • tyleharris's avatar
    tyleharris
    Frequent Visitor
    6 years ago

    Anonymous,

    I unfortunately have no idea what my data model looks like. I'm an end user with a live connection so I can't see what the relationships look like.

    Do you mean a date table or data table, as in the datatable() function? If date table, I have a calendar table, but when I try to use that instead of the transaction table it doesn't return the correct values.