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.
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_Deckler
3 years agoCommunity Champion
BobMcC That would be my opinion, yes.