Forum Discussion

natasha519's avatar
natasha519
Icon for Helper II rankHelper II
4 years ago

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's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
    natasha519
    Icon for Helper II rankHelper II
    4 years ago

    I am getting an unexpected expression error as soon as I insert a comma