Forum Discussion
Dax Scoring System
Hi MarkButterfield
can you simply write below calulation
Score =
var E= If(ISBLANK(Personal Email),0,If([Personal Email]="N/A",10),50)
var B= If(ISBLANK(Business Email),0,If([Business Email]="N/A",10),50)
var P= If([Preferred Email]="NO", 0,50)
Return E+B+P
If my post helps please give kudos and accept it as solution!
Thanks
Hi,
Thanks for this. I used this formula, but had to add closed parentheses on Var E And B for the formula to be accepted.
However, even after this formula, I still get an incorrect value.
I created 3 new columns to check whether the values were being read correctly, and that raised no issues.
I really thought that this would be a simple calculation!
I'm still getting a score of 100 when the personal and preferred email columns are blank and "No" respectively
I have taken your sample data set.
I got the desired result. please create the following Measure :Total Score =var B=IF(MIN('Email Score'[Business Email])="",0,IF(MIN('Email Score'[Business Email])="N/A",10,50))Var P= IF(MIN('Email Score'[Personal Email])="",0,IF(MIN('Email Score'[Personal Email])="N/A",10,50))var Q= IF(MIN('Email Score'[Preferred Email])="" || MIN('Email Score'[Preferred Email])="N/A",0,50)Return (B+P+Q)If I answered your question please give kudos and accept it as a solution!
ThanksHi MarkButterfield
Did you try above solution ???
I have tested with your dataset.
IF my post helps please give kudos and accept it as asolution!
Thanks