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...
With the formula I outlined above, when the:
Business email contains a value
Personal email is blank
Preferred email is blank
I should be getting a score of 50
But I'm currently getting 100
Some part of the formula must be incorrect?
Or if the formula works correctly, I need to somehow edit my underlying data!