How can I make this measure faster?

[ffunky]

I made this measure because the Totals in my matrix weren't adding up correctly, but now my matrix is super slow.

Volume_Sales = sumx('Weekly Sales',CALCULATE(sum(_PKG_PACKAGE_MASTER_ITEM[CE_FACTOR])*[Units_Sold_Measure]))

[Units_Sold_Measure] is just a sum of a column.

Thanks!

Jason

[v-eachen-msft]

Hi @ffunky ,

You could refer to this video:

https://www.sqlbi.com/tv/my-power-bi-report-is-slow-what-should-i-do/

[amitchandak · Accepted solution]

First of we need make sure where should be mutliple _PKG_PACKAGE_MASTER_ITEM[CE_FACTOR and Units_Sold_Measure.

Let us say it we have qty and unit price. We can not create a meausre

sum(qty)*sum(unit price)

We need a column Value = qty*[unit price], now we can sum.

Now if it case like find unit price and we have Value and Unit then Avg if Value/qtywill not give correct answer . We have to create a measure unit price =sum(value)/sum(qty)

Not sure of the dat model. But you might have to create a column. It depend on what calcultion you have for Units_Sold_Measure

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[ffunky]

Thank you @amitchandak .  Creating columns and then referencing those seems to work much better!

[mwegener]

Hi @ffunky ,

can you give an overview of your data model?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.