Forum Discussion
MarkButterfield
2 years agoNew Member
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...
MarkButterfield
2 years agoNew Member
Hi,
Thanks for your reply!
Based on the scoring system outlined above, the total score would adjust based on the data available:
| Business Email | Personal Email | Preferred Email | Contact Score |
| "[email protected]" | "[email protected]" | Business | 150 |
| "[email protected]" | N/A | Business | 110 |
| "[email protected]" | Business | 100 | |
| "[email protected]" | 50 | ||
| 0 |