Forum Discussion
Dax Scoring System
Hi everyone, I want to calculate a score based on whether data is present or absent in my dataset. A. Personal Email Address = 50 points If Personal Email is N/A = 10 points If Personal Emai...
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!
Thanks
Hi 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