Forum Discussion
BobMcC
3 years agoNew Member
Measure Returning
Hello, I've been trying to proof out a .pbix. I'm having an issue with one of the measures. The measure name is WA LTV Locked All = IF(SUM('dmLoanInfo'[LoanAmount]) > 0 ,SUMX('dmLoanInfo',[LTV]...
- 3 years ago
BobMcC That would be my opinion, yes.
Greg_Deckler
Community Champion
3 years agoBobMcC This is my best understanding of how to create a Weighted Average.
Better Weighted Average per Category - Microsoft Power BI Community
BobMcC
3 years agoNew Member
Thanks for the link Greg. Just watched the clip. Ultimately, it looks like your original post
aligns with his version of the Better Weighted Average Per Category
WA LTV Locked All =
IF(
SUM('dmLoanInfo'[LoanAmount]) > 0 ,
VAR __1 = SUMX('dmLoanInfo',[LTV]*[LoanAmount])
VAR __2 = SUM('dmLoanInfo'[LoanAmount])
VAR __3 = __1 / __2
RETURN
__3,
BLANK()
)If that is the case, would you agree that the original measure is incorrect and should be changed to the version you sent? Not asking you to make a ruling 🙂 just asking for your opinion. Thanks!
btw: I did vote for the idea per your tag line link.
- Greg_Deckler3 years ago
Community Champion
BobMcC That would be my opinion, yes.