Forum Discussion

natasha519's avatar
natasha519
Helper 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...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi natasha519 ,

 

Numerator =
VAR _count =
    CALCULATE (
        COUNTROWS ( DOSE_Timeliness ),
        FILTER ( DOSE_Timeliness, DOSE_Timeliness[Timeliness Icon Status] = 1 ),
        FILTER ( 'LatestData', NOT ( ISBLANK ( 'LatestData'[name] ) ) )
    )
RETURN
    IF (
        SELECTEDVALUE ( 'Jurisdiction Filter'[Recipient] )
            IN { "California", "Hawaii", "Iowa", "Minnesota", "Oklahoma", "Puerto Rico" },
        _count,
        _count
    )

One wired thing in your formula, the if function returns the same count when it gets right or wrong?

 

Best Regards,

Jay