Forum Discussion
Weighted average responding to slicers
Hello, I'm sharing the pbix file because I've searched high and low for this, as well as asking here before, but haven't been able to figure it out. Dynamic Weighted Average Test I'm tryi...
Give this a try for your Weight measure.
Weight = DIVIDE ( [SumProduct], CALCULATE ( [SumProduct], ALLSELECTED ( Sheet1[DSO] ) ) )
I put a copy of my testing file up for you to take a look at. It also uses SUMX instead of a calculated column to get SumProduct.
https://www.dropbox.com/s/xmm25c0ahs58cxk/Weighted%20Avg%20DSO.pbix?dl=0
Anonymous - Yes, it's true that Calculated Columns are calculated when the data is refreshed/processed. The value is stored in each row. Measures are calculated at query time. You want to use a measure for your weight, because your total needs to react to user interaction.
Hope this helps,
Nathan