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...
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
If you want to handle ISBLANK() with prefered email then use below calculation
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(ISBLANK[Preferred Email] || [Preferred Email]="No",0,50)
Return E+B+P
If my post helps please give kudos and accept it as a solution!
Thanks