Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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] )
)
Solved! Go to 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
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
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
Works great. TY.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |