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
jdbuchanan71
Super User
Super UserGive 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