Forum Discussion
natasha519
4 years agoHelper II
Help with Measure
I have a measure with this formula: Numerator = if(or(or(or(or(or(SELECTEDVALUE('Jurisdiction Filter'[Recipient])="California",SELECTEDVALUE('Jurisdiction Filter'[Recipient])="Hawaii"),SELECTEDV...
amitchandak
4 years agoSuper User
natasha519 , should work if tables are joined
Numerator = calculate(if(or(or(or(or(or(SELECTEDVALUE('Jurisdiction Filter'[Recipient])="California",SELECTEDVALUE('Jurisdiction Filter'[Recipient])="Hawaii"),SELECTEDVALUE('Jurisdiction Filter'[Recipient])="Iowa"),SELECTEDVALUE('Jurisdiction Filter'[Recipient])="Minnesota"),SELECTEDVALUE('Jurisdiction Filter'[Recipient])="Oklahoma"),SELECTEDVALUE('Jurisdiction Filter'[Recipient])="Puerto Rico"),Countrows(Filter(DOSE_Timeliness,DOSE_Timeliness[Timeliness Icon Status]=1)),countrows(Filter(DOSE_Timeliness,DOSE_Timeliness[Timeliness Icon Status]=1)) ) , filter('LatestData', not(isblank ('LatestData'[name]))) )
natasha519
4 years agoHelper II
I am getting an unexpected expression error as soon as I insert a comma