FIND - using more than one

[Qotsa]

Hi,

The below measure sums [Charged_Hrs] only when  'ClientsList'[ClientMH3Name] = "HSE Cover".

How do I modify this to sum [Charged_Hrs] only when  'ClientsList'[ClientMH3Name] = "HSE Cover" 

OR

'ClientsList'[USER5] = "HSE Cover"

Cover Hrs =
CALCULATE (
    CALCULATE (
        CALCULATE (
            SUM ( vw_ShowChargesAndPayForVisits[Charged_Hrs] ),
            FILTER ( 'ClientsList', FIND ( "HSE Cover", 'ClientsList'[User5],, 0 ) ),
            FIND ( "HSE Cover", 'ClientsList'[ClientMH3Name],, 0 )
        ),
        USERELATIONSHIP ( 'Year'[Year], vw_ShowChargesAndPayForVisits[Year] )
    ),
    USERELATIONSHIP ( 'Week'[Week], vw_ShowChargesAndPayForVisits[Weeks] )
)

[v-diye-msft]

Hi @Qotsa 

Please use the formula below instead:

Cover Hrs =
CALCULATE (
    CALCULATE (
        CALCULATE (
            SUM ( vw_ShowChargesAndPayForVisits[Charged_Hrs] ),
            FILTER (
                ClientsList,
                FIND ( "HSE Cover", 'ClientsList'[User5],, 0 )
                    || FIND ( "HSE Cover", 'ClientsList'[ClientMH3Name],, 0 )
            ),
            USERELATIONSHIP ( 'Year'[Year], vw_ShowChargesAndPayForVisits[Year] )
        ),
        USERELATIONSHIP ( 'Week'[Week], vw_ShowChargesAndPayForVisits[Weeks] )
    )
)

Best regards,

Dina Ye

[v-diye-msft · Accepted solution]

Hi @Qotsa ,

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

Best regards,

Dina Ye

[Qotsa]

Works great. TY.