Forum Discussion

MarkButterfield's avatar
MarkButterfield
New Member
2 years ago

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...
Need Help
MarkButterfield's avatar
MarkButterfield
New Member
2 years ago

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

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi MarkButterfield 

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

 

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    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