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

Hi natasha519 

 

First, I think you can use this rather thatn using many OR in the formula:

Numerator =
IF (
    SELECTEDVALUE ( 'Jurisdiction Filter'[Recipient] )
        IN { "California", "Hawaii", "Iowa", "Minnesota", "Oklahoma", "Puerto Rico" },
    COUNTROWS (
        FILTER ( DOSE_Timeliness, DOSE_Timeliness[Timeliness Icon Status] = 1 )
    ),
    COUNTROWS (
        FILTER ( DOSE_Timeliness, DOSE_Timeliness[Timeliness Icon Status] = 1 )
    )
)

 

Where do you want to add a new filter, in the result or in the statement?

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/