Count total by name, but reduce those with "Asbuilt" by 50% in my totals

[BillyT]

Hello,

I need to count all task by name from TT_TASK [name], but those with "Asbuilt" in thier name, like Coax Asbuilt QC I want to reduce the total by 50%.  What would be the best way to get this?

 

[v-jiascu-msft]

Hi @BillyT,

Could you please mark the proper answers as solutions?

Best Regards,
Dale

[v-jiascu-msft]

Hi @BillyT,

Maybe you can integrate the calculation with your current formula like below. If you'd like a more precise solution, please provide a dummy sample file.

measure =
IF (
    FIND ( "Asbuilt", MIN ( TT_TASK[name] ),, 0 ) = 0,
    COUNT ( TT_TASK[name] ),
    COUNT ( TT_TASK[name] ) * 0.5
)

Best Regards,

Dale