Formula

[JoseGarcia]

Hi there, 

Master measure below does not apply when I select a project.

Count({<[Project Name]>} IF([Physical % Complete] <'100%', [Project Name]))

Is there any other way I can re-formulate this expression so that when I select project  it returns related values?
Thanks a million

Jose

[JoseGarcia]

the formula behind Total completed: 

Count number of rows with Project Name in Column A and equal to 100% in Column J

Does this hep?

[NitinK7]

try below steps

1. Need to remove % sign in value at script level

Load

"ActOwner (A)",
"Physical % Complete",
Num("Physical % Complete",'#,##')*100 as "Physical % Complete1",
Variance  ;

then use exp like below

=Count( {< [Physical % Complete1] ={"<100"} >} [Project Name] )

[NitinK7]

do you want equal to 100 or less than 100??

if equal to 100 then

=Count( {< [Physical % Complete1] ={"100"} >} [Project Name] )

[agigliotti · Accepted solution]

make this modification in the script to create a primary key:

([Project Name] &
ActivityID & [Activity Name] ) as KEY0;

in UI:

=Count( {< KEY0 = {"=[Physical % Complete]=1"} >} KEY0 )

[JoseGarcia]

@agigliotti , @NitinK7 

Successssssss  🤓

Both, thanks a million for the support! 
It worked. 

Just need to recreate pattern to suit other formulas.
🙂