Forum Discussion
Solved
Weighted Average Question
Updated: 3/2/2023 @ 250PM Hi, I have an issue I ran into with using a quick measure for weighted average. I listed my formula below. But basically realized my issue is that the "Value" formula...
azale2407 , Try like
Divide(SUMX('Sample Table','Sample Table'[LTV] * 'Sample Table'[UPB]), calculate( SUM('Sample Table'[UPB]), allselected()))
azale2407 , Try like
Divide(SUMX('Sample Table','Sample Table'[LTV] * 'Sample Table'[UPB]), calculate( SUM('Sample Table'[UPB]), allselected()))